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
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
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,
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
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
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
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:
7 matches
Mail list logo