try DATE('now','localtime')
--- On Tue, 6/30/09, Goldstein, Ian <[email protected]> wrote:
From: Goldstein, Ian <[email protected]>
Subject: [sqlite] Time format
To: [email protected]
Date: Tuesday, June 30, 2009, 12:07 AM
Hello, I am one day into sqlite and have probably a very simple problem
involving datetime function.
It seems, there is a 4 hour difference between what is in the db and my
real time.
For example:
date;sqlite3 ian.db "select (datetime('now'))"
Tue Jun 30 00:05:35 EDT 2009
2009-06-30 04:05:35
Thanks
Ian
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
