> It turns out that 2010-10-24 is 257 days from the very first partition in > my dataset (2010-01-09): > > | date_sub('2010-10-24',interval 257 day) | > +-----------------------------------------+ > | 2010-02-09 | >
I just noticed 257 days is FEBRUARY 9th, not JANUARY 9th, as the above shows. So there isn't even a 256ness of this problem in the first place. The human brain tends to pay attention to beginnings and ends of strings, ignoring the middle. -- Tim Ellis Riot Games