View Single Post
Old 11-04-2024, 05:40 AM   #750
chaley
Grand Sorcerer
chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.
 
Posts: 12,460
Karma: 8025600
Join Date: Jan 2010
Location: Notts, England
Device: Kobo Libra 2
Quote:
Originally Posted by ownedbycats View Post
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?
chaley is offline   Reply With Quote