On 9/27/2017 8:06 PM, Stephen Chrzanowski 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?
Yes. A Julian day starts at noon, not midnight. strftime('%H:%M',-0.5); would
give you midnight of that day.
--
Igor Tandetnik
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
