Perfect. Thanks guys. Thanks Igor for the proper offset as well. I'll
file that for later reference. :]
On Wed, Sep 27, 2017 at 8:13 PM, Igor Tandetnik <i...@tandetnik.org> wrote:
> 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
>
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
