Re: Weird problem for TIMESTAMP feild

2004-07-26 Thread SGreen
According to the docs (http://dev.mysql.com/doc/mysql/en/DATETIME.html) The number "1258975462" equates to the date "1258-97-54 62:00:00" which is not a valid date. That's why you get the "zero date" value. That number could also equate to a unix_timestamp() value for the date "2009-11-23 06:24

RE: Weird problem for TIMESTAMP feild

2004-07-26 Thread Victor Pendleton
Invalid entry format for the timestamp field. Did this work before? -Original Message- From: Tariq Murtaza To: [EMAIL PROTECTED] Sent: 7/26/04 4:43 AM Subject: Weird problem for TIMESTAMP feild Hi All, I am getting very weired problem after shifting our server. here is the details:- I