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?
I'll either adjust the actual query I'm working on, or scrap it and have
the program deal with converting minutes to Hours:Minutes. (Kind of
thinking the later, since I don't seem to be able to get a zero day output)
_______________________________________________
sqlite-users mailing list
[email protected]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
