Re: [sqlite] UTC/GMT conversion back and forth

[Ted Rolle, Jr.]

On Fri, 28 May 2010 20:12:54 +0300
Andrejs Igumenovs  wrote:

Finally! A question that I can answer.
For all practical (and most impractical)
(Drum roll)
UTC = GMT, or alternatively,
GMT = UTC

UTC is Coordinated Universal Time, which one would think would be
abbreviated CUT, but one French-speaking country got its two cents in
there, so we know it as UTC.

-- 
__
3.14159265358979323846264338327950  Let the spirit of pi
2884197169399375105820974944592307   spread all over the world!
8164062862089986280348253421170679 http://pi314.at  PI VOBISCUM!
==
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] UTC/GMT conversion back and forth

[Black, Michael (IS)]

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: sqlite-users-boun...@sqlite.org on behalf of Andrejs Igumenovs
Sent: Fri 5/28/2010 12:12 PM
To: sqlite-users@sqlite.org
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
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

[sqlite] UTC/GMT conversion back and forth

[Andrejs Igumenovs]

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
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users