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

2005-12-21 Thread Murray @ PlanetThoughtful
[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 recorded / displayed

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

2005-12-21 Thread Derrell . Lipman
"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 recorded / displayed incorrectly. For > example, it's

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

2005-12-21 Thread rbundy
users@sqlite.org | | cc: | | Subject: [sqlite] CURRENT_TIMESTAMP records / displays

[sqlite] CURRENT_TIMESTAMP records / displays incorrect value?

2005-12-21 Thread Murray @ PlanetThoughtful
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