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

2010-05-29 Thread 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

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

2010-05-29 Thread Black, Michael (IS)
ject: [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 o

[sqlite] UTC/GMT conversion back and forth

2010-05-29 Thread 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!