[sqlite] 2nd question about 'localtime'

Hi All, I have a second question re: dates in SQLite and 'localtime'. I have a table with a DEFAULT CURRENT_TIMESTAMP field. I'm trying to retrieve a recordset of records that have been added to that table today (but, of course, because the field stores UTC, the value for the majority of

Re: [sqlite] CURRENT_TIMESTAMP records / displays incorrect value?

[EMAIL PROTECTED] wrote: "Murray @ PlanetThoughtful" <[EMAIL PROTECTED]> writes: 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 reco

[sqlite] CURRENT_TIMESTAMP records / displays incorrect value?

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