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.
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');
sqlite> select date('1220249914','unixepoch');
Mail list logo