Hello All, New to the list, so please forgive if this has been discussed previously.
I have a column defined with DEFAULT CURRENT_TIMESTAMP in an SQLite 3.2.7 db (on WinXP SP2, if that's important). I've noticed that the value being stored in that column is being recorded / displayed incorrectly. For example, it's currently 5:28am 22 Dec 2005 (in Australia, if that causes confusion), and yet a record inserted at this point contains "2005-12-21 19:28:54" when SELECTed back from the table.
Is this a known issue? I wondered if there was a time offset setting, but haven't been able to find one in the documentation.
Any help appreciated! Much warmth, Murray