On Wed, 2005-08-31 at 15:46 -0700, Clark Christensen wrote:
> Using Sqlite v3.2.5 on both Linux, and Windows, I'm having
> some difficulty reconciling unixepoch seconds with other
> tools. Consider this:
>
> select strftime('%s', '2005-08-30 15:19:00');
>
> returns 1125415140
>
> If I take that resulting value and feed it to localtime()
> in Perl, either under Windows or Linux, the resulting
> date/time value is "2005-08-30 08:19:00"
>
SQLite works in UTC (aka GMT) not in localtime.
--
D. Richard Hipp <[EMAIL PROTECTED]>
