On 9/27/17, Stephen Chrzanowski <[email protected]> wrote: > Messing around tonight with a work project, dealing with times, I noticed > the following: > > C:\Users\Stephen>sqlite3 > SQLite version 3.8.10.1 2015-05-09 12:14:55 > Enter ".help" for usage hints. > Connected to a transient in-memory database. > Use ".open FILENAME" to reopen on a persistent database. > sqlite> select strftime('%H:%M',0.0); > 12:00 > > I would have expected 0:00, not 12:00. Does this tie into julianday being > a 12 hour offset? >
https://en.wikipedia.org/wiki/Julian_day Julian days start at noon. So, yes, 0.0 is noon. If you want midnight, that's 0.5. -- D. Richard Hipp [email protected] _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
