Re: [sqlite] Bug in conversion from unixepoch

2008-09-01 Thread Brandon Fosdick
Myk Melez wrote: > Unix times contain no time zone information (they are relative to an > epoch in the UTC time zone), and SQLite's date/time functions return > values in the UTC time zone by default: argh, I should have thought of that. Thanks. ___

Re: [sqlite] Bug in conversion from unixepoch

2008-09-01 Thread Myk Melez
Brandon Fosdick wrote: > sqlite> select date('1220302462','unixepoch'); > 2008-09-01 > sqlite> select date('1220249914','unixepoch'); > 2008-09-01 > Unix times contain no time zone information (they are relative to an epoch in the UTC time zone), and SQLite's date/time functions return

[sqlite] Bug in conversion from unixepoch

2008-09-01 Thread Brandon Fosdick
Using sqlite 3.4.0 (on both OS X 10.5.4 and iPhone 2.0.2) I'm seeing a problem converting unix timestamps from today and yesterday. In the sqlite console I get... sqlite> select date('1220302462','unixepoch'); 2008-09-01 sqlite> select date('1220249914','unixepoch'); 2008-09-01 ...however, the