sqlite> create table t (d integer);
sqlite> insert into t values (datetime('now'));
sqlite> select * from t;
2010-05-29 11:19:20 << you'll note this should be in GMT
sqlite> select datetime(d,'localtime') from t;
2010-05-29 06:19:20
You can, of course, get your time in whatever format you want.
http://www.sqlite.org/lang_datefunc.html
Michael D. Black
Senior Scientist
Northrop Grumman Mission Systems
________________________________
From: [email protected] on behalf of Andrejs Igumenovs
Sent: Fri 5/28/2010 12:12 PM
To: [email protected]
Subject: [sqlite] UTC/GMT conversion back and forth
Hi,
I've got dates and times stored in GMT.
When I perform my calculations using date() function for ex., i need
to use those dates and times normalized to the current location I'm
now in (this is variable).
This thing makes me lost a bit of how to implement.. Any ideas ?
Thanks!
_______________________________________________
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
