k thanks expertz
Pavel Ivanov-2 wrote:
>
>> 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
>
>
--
View this message in context:
http://old.nabble.com/Error-in-retreiving-DATETIME%28%27NOW%27%29-tp26829800p26841341.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
