Re: [sqlite] 2nd question about 'localtime'

oughtful"| | | >--| | | | To: sqlite-users@sqlite.org | | cc: | | Subject: [sqlite] 2nd question

Re: [sqlite] 2nd question about 'localtime'

Murray @ PlanetThoughtful wrote: 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,

[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