SELECT DATETIME('NOW','localtime'); is WORKED
but i want to use my localtime as default time in sqlite(without giving
'localtime'). is it possible?
Greensparker
SimonDavies wrote:
>
> 2009/12/17 greensparker <balamurugan.c...@gmail.com>:
>>
>> hi,
>> im having a error in retreiving the DATETIME from SQLITE
>> im in DEBIAN.
>> when i give SELECT DATETIME('NOW')
>> im getting the TIME : 2009-12-17 15:35
>> but my system time is : 2009-12-17 21:05 IST
>>
>> my timezone is INDIA. IST.
>>
>> pls tell me, why DATETIME() function gives wrong time?
>
> Have you tried
> SELECT DATETIME('NOW','localtime'); ?
>
> See http://www.sqlite.org/lang_datefunc.html
>
>>
>> Greensparker
>
>
> Regards,
> Simon
> _______________________________________________
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
>
--
View this message in context:
http://old.nabble.com/Error-in-retreiving-DATETIME%28%27NOW%27%29-tp26829800p26830439.html
Sent from the SQLite mailing list archive at Nabble.com.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
