Would this be covered by the change in
http://www.sqlite.org/cvstrac/tktview?tn=1216 and its
related check-in?
--- Clark Christensen <[EMAIL PROTECTED]> 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"
>
> The same thing happens using a JavaScript Date object:
>
> var epochdate = new Date(1125415140*1000);
> document.write(epochdate.toString());
>
> prints "Tue Aug 30 08:19:00 PDT 2005" in MSIE under
> Windows.
>
> Server-side JavaScript (Solaris on the server)
>
> var epochdate = new Date(1125415140*1000);
> Response.write(epochdate.toString());
>
> prints "Tue Aug 30 08:19:00 GMT-0700 (PDT) 2005".
>
> It's similar with other date strings, but the difference
> in
> the hours isn't always the same.
>
> Am I missing something?
>
> Thanks!
>
> -Clark
>
>
