MySQL Forums
Forum List  »  Newbie

Timestamp trouble.
Posted by: Beau Beveridge
Date: April 22, 2005 10:19PM

I'm using PHP 4.3.8 and MySQL 3.23.58. I'm collecting data from an HTML form which then uses PHP to insert the information into a table in MySQL. In the table I have a field that's type is TIMESTAMP. My problem is that it seems no matter what I try that field is always entered as 00000000000000. The field is set as NULL; I thought it was supposed to be NOT NULL but it won't let me change it. Using PHP I've tried sending nothing (''), a now() function and entering the info manually but I can't figure out what I'm supposed to be doing.

Options: ReplyQuote


Subject
Written By
Posted
Timestamp trouble.
April 22, 2005 10:19PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.