> > - Hive seems to truncate timestamps towards negative infinity when it has > to reduce precision. > > I lean towards truncating - theoretically rounding introduces smaller > error, but it can move the timestamp to a different day / DST rule / year
I'm familiar with rounding towards negative infinity and truncation, but my understanding of those is different, in that -1.5 rounded to negative infinity is -2, while -1.5 truncated is -1. Does this timestamp format allow negative timestamps? https://en.wikipedia.org/wiki/Floating-point_arithmetic#Rounding_modes
