> but i want to use my localtime as default time in sqlite(without giving
> 'localtime'). is it possible?
No. And documentation clearly says about that.
Pavel
On Thu, Dec 17, 2009 at 11:08 AM, greensparker
<balamurugan.c...@gmail.com> wrote:
>
> 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
>
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
