Re: [sqlite] sqlite time is 2 hours to late

2012-06-27 Thread Black, Michael (IS)
From: sqlite-users-boun...@sqlite.org [sqlite-users-boun...@sqlite.org] on behalf of Black, Michael (IS) [michael.bla...@ngc.com] Sent: Wednesday, June 27, 2012 11:18 AM To: General Discussion of SQLite Database Subject: EXT :Re: [sqlite] sqlite time is 2 hours to late Kinda' depend on what e

Re: [sqlite] sqlite time is 2 hours to late

2012-06-27 Thread Doug Nebeker
> UTC is "the right time." If you're doing anything with dates and > times I would STRONGLY recommend that all recorded times are in UTC. Jay is right. I've been bitten by storing local times before. Even if your users are in the same time zone, that time zone shifts with day light savings.

Re: [sqlite] sqlite time is 2 hours to late

2012-06-27 Thread Black, Michael (IS)
vanced GEOINT Solutions Operating Unit Northrop Grumman Information Systems From: sqlite-users-boun...@sqlite.org [sqlite-users-boun...@sqlite.org] on behalf of deltagam...@gmx.net [deltagam...@gmx.net] Sent: Wednesday, June 27, 2012 10:45 AM To: j...@kreibi.ch; General Discussion of SQLite D

Re: [sqlite] sqlite time is 2 hours to late

2012-06-27 Thread Etienne
Fully agree with you, Jay. -> SQLite NUL "select datetime('now','localtime');" E. On Wed, Jun 27, 2012, at 10:55, Jay A. Kreibich wrote: > On Wed, Jun 27, 2012 at 05:45:41PM +0200, deltagam...@gmx.net scratched on > the wall: > > Am 27.06.2012 17:40, schrieb Jay A. Kreibich: > > >On Wed, Jun 2

Re: [sqlite] sqlite time is 2 hours to late

2012-06-27 Thread Jay A. Kreibich
On Wed, Jun 27, 2012 at 05:45:41PM +0200, deltagam...@gmx.net scratched on the wall: > Am 27.06.2012 17:40, schrieb Jay A. Kreibich: > >On Wed, Jun 27, 2012 at 05:37:55PM +0200, deltagam...@gmx.net scratched on > >the wall: > > > >>Hello, > >> > >>>sqlite3 event.db "select datetime('now')"; > >>g

Re: [sqlite] sqlite time is 2 hours to late

2012-06-27 Thread deltagam...@gmx.net
Am 27.06.2012 17:40, schrieb Jay A. Kreibich: On Wed, Jun 27, 2012 at 05:37:55PM +0200, deltagam...@gmx.net scratched on the wall: Hello, sqlite3 event.db "select datetime('now')"; gives me a time that is 2 hours too late ( 2012-06-27 15:33:13) than my system time ( win 7 ) 17::33:13 How

Re: [sqlite] sqlite time is 2 hours to late

2012-06-27 Thread Jay A. Kreibich
On Wed, Jun 27, 2012 at 05:37:55PM +0200, deltagam...@gmx.net scratched on the wall: > Hello, > > >sqlite3 event.db "select datetime('now')"; > gives me a time that is 2 hours too late ( 2012-06-27 15:33:13) > than my system time ( win 7 ) 17::33:13 > > How can this be fixed ? Move two ti