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
<[email protected]> wrote:
> 2009/10/8 Fredrik Karlsson <[email protected]>:
>> Hi,
>>
>>
>>
>> On Thu, Oct 8, 2009 at 12:04 AM, P Kishor <[email protected]> wrote:
>>> On Wed, Oct 7, 2009 at 5:02 PM, Fredrik Karlsson <[email protected]> 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 datetime();"
>>>> 2009-10-07 21:56:58
>>>>> sqlite3 temp.sqlite "SELECT datetime('now);"
>>>> SQL error: unrecognized token: "'now);"
>>>>> sqlite3 temp.sqlite "SELECT datetime('now');"
>>>> 2009-10-07 21:57:13
>>>>> sqlite3 temp.sqlite "SELECT time('now');"
>>>> 21:59:05
>>>>
>>>> What happened here? How come the time functions are off 2 hours?
>>>> (I am using sqlite version 3.5.9 on a Mac OS Leopard machine)
>>>>
>>>
>>>
>>> time zones. The sqlite returned times, by default, are UTC.
>>>
>>
>> Yes, that would have been my guess too, but I am on CET, which I
>> understand is UTC+1. So, I am still getting one hour less than I
>> should from SQLite. Or, am I doing something stupid?
>
> From above, you are currently on CEST, which is UTC+2
>
>>
>> /Fredrik
>> "Life is like a trumpet - if you don't put anything into it, you don't
>> get anything out of it."
>
>
> Regards,
> Simon
> _______________________________________________
> sqlite-users mailing list
> [email protected]
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
--
"Life is like a trumpet - if you don't put anything into it, you don't
get anything out of it."
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
