[thelist] mysql: timestamp fields all changed to 11th March 2000
Dunstan Orchard
dunstan at 1976design.com
Tue Nov 25 07:07:21 CST 2003
Hi there,
I recently swapped all my data from one database to another, and in the
process I've found that most (but not all) of my dates in a TIMESTAMP
field have changed to 11th March 2000.
My field type is:
cmnt_date timestamp(10) NOT NULL,
What I did:
[1] Exported all the tables in my original database to a sql file.
[2] Uploaded this sql file into the new database to create all the
tables with their data.
The timestamps in the sql files are correct, but when I loaded them into
the new db, 90% of them seem to have changed to 11th March 2000.
Can anyone tell me:
[1] Why!
[2] How to get around this without manually updating them all (which
works, as I've started doing it)
Thanks very much - Dunstan
-------------------------------------
Dorset, England
Work: http://www.1976design.com/
Play: http://www.1976design.com/blog/
Learn: http://webstandards.org/
More information about the thelist
mailing list