Duh! :-))
Thanks!
--- "D. Richard Hipp" <[EMAIL PROTECTED]> wrote:
> 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]>
>
>
