Re: [sqlite] unixepoch seconds issue?

2005-08-31 Thread Clark Christensen
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: > > > >

Re: [sqlite] unixepoch seconds issue?

2005-08-31 Thread Lawrence Chitty
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 This is the UTC time (sort of the same as GMT I think). You

Re: [sqlite] unixepoch seconds issue?

2005-08-31 Thread Clark Christensen
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.

[sqlite] unixepoch seconds issue?

2005-08-31 Thread Clark Christensen
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