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 
values in the UTC time zone by default:

sqlite> select datetime('1220302462','unixepoch');
2008-09-01 20:54:22
sqlite> select datetime('1220249914','unixepoch');
2008-09-01 06:18:34

But you can make them return values in the local time zone with the 
|localtime| modifier:

sqlite> select datetime('1220302462','unixepoch', 'localtime');
2008-09-01 13:54:22
sqlite> select datetime('1220249914','unixepoch', 'localtime');
2008-08-31 23:18:34

> 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.
That's just a coincidence. MySQL's from_unixtime 
<http://dev.mysql.com/doc/refman/5.0/en/date-and-time-functions.html#function_from-unixtime>
 
returns values in the "current time zone," so if you'd changed zones 
since inserting the records, it would show you different values.

-myk

_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to