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
