> pls tell me, why DATETIME() function gives wrong time?
http://www.sqlite.org/lang_datefunc.html
"Format 11, the string 'now', is converted into the current date and
time as obtained from the xCurrentTime method of the sqlite3_vfs
object in use. Universal Coordinated Time (UTC) is used."
Use datetime('now', 'localtime') if you want time in your timezone.
Pavel
On Thu, Dec 17, 2009 at 10:34 AM, greensparker
<balamurugan.c...@gmail.com> wrote:
>
> 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?
>
> Greensparker
> --
> View this message in context:
> http://old.nabble.com/Error-in-retreiving-DATETIME%28%27NOW%27%29-tp26829800p26829800.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
