Quote:
Originally Posted by ownedbycats
Ah yeah, I think that's what I was trying to do.
As long as I use $(field) instead of $$(raw_field) in the date argument, would that make it line up to midnight (assuming a datetime column)?
|
Depends on how 'field' is formatted. If it is formatted without time information then yes unless some part of the conversion chain does rounding. You do need to decide what to do with fractional days. Said another way, exactly what is a day? Is it 24 hours or a change of the calendar? Should 00:01 - 23:59 be one day, which is what will happen if comparing calendar days instead of durations.
I also must ask: why is this precision so important? Why not let a day be 24 hours, making everything easier?