Re: [sqlite] Datetime mystery

2009-10-09 Thread Peter van Dijk
On Oct 8, 2009, at 16:16 , Jay A. Kreibich wrote: > On Thu, Oct 08, 2009 at 08:29:10AM +0200, Fredrik Karlsson scratched > on the wall: > >> Yes, that would have been my guess too, but I am on CET, which I >> understand is UTC+1. CET is CEST in summer, which is UTC+2 Cheers, Peter

Re: [sqlite] Datetime mystery

2009-10-08 Thread Jay A. Kreibich
rlsson <dargo...@gmail.com> To: punk...@eidesis.org, General Discussion of SQLite Database <sqlite-users@sqlite.org> Subject: Re: [sqlite] Datetime mystery -j -- Jay A. Kreibich < J A Y @ K R E I B I.C H > "Our opponent is an alien starship packe

Re: [sqlite] Datetime mystery

2009-10-08 Thread Fredrik Karlsson
Hi, Yes! That's it! Sorry about the stupid question then.. select datetime('now','localtime'); seems to do what I want. /Fredrik On Thu, Oct 8, 2009 at 9:39 AM, Simon Davies wrote: > 2009/10/8 Fredrik Karlsson : >> Hi, >> >> >> >> On Thu,

Re: [sqlite] Datetime mystery

2009-10-08 Thread Simon Davies
2009/10/8 Fredrik Karlsson : > Hi, > > > > On Thu, Oct 8, 2009 at 12:04 AM, P Kishor wrote: >> On Wed, Oct 7, 2009 at 5:02 PM, Fredrik Karlsson wrote: >>> Dear list, >>> >>> I am sorry if I am asking a FAQ, but what is differnent with

Re: [sqlite] Datetime mystery

2009-10-08 Thread Fredrik Karlsson
Hi, On Thu, Oct 8, 2009 at 12:04 AM, P Kishor wrote: > On Wed, Oct 7, 2009 at 5:02 PM, Fredrik Karlsson wrote: >> Dear list, >> >> I am sorry if I am asking a FAQ, but what is differnent with >> datetime() and time()? >> >>> date # This is the correct

Re: [sqlite] Datetime mystery

2009-10-07 Thread P Kishor
On Wed, Oct 7, 2009 at 5:02 PM, Fredrik Karlsson wrote: > Dear list, > > I am sorry if I am asking a FAQ, but what is differnent with > datetime() and time()? > >> date # This is the correct time on the system > Ons  7 Okt 2009 23:56:36 CEST >> sqlite3 temp.sqlite "SELECT

[sqlite] Datetime mystery

2009-10-07 Thread Fredrik Karlsson
Dear list, I am sorry if I am asking a FAQ, but what is differnent with datetime() and time()? > date # This is the correct time on the system Ons 7 Okt 2009 23:56:36 CEST > sqlite3 temp.sqlite "SELECT datetime();" 2009-10-07 21:56:58 > sqlite3 temp.sqlite "SELECT datetime('now);" SQL error: