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 equivalent in MySQL produces...
mysql> select from_unixtime(1220302462);
+---------------------------+
| from_unixtime(1220302462) |
+---------------------------+
| 2008-09-01 13:54:22 |
+---------------------------+
1 row in set (0.00 sec)
mysql> select from_unixtime(1220249914);
+---------------------------+
| from_unixtime(1220249914) |
+---------------------------+
| 2008-08-31 23:18:34 |
+---------------------------+
1 row in set (0.00 sec)
The MySQL version is correct in the sense that it returns dates/times
that correspond to what my clock said when I created the records that
contain the timestamps in question. This was all done in the Pacific
timezone and the records were created on my iPhone.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
