If you need a timestamp that is automatically updated when a record is inserted, replaced, or updated, declare one field in the record as TIMESTAMP:
create table mytable ( myvalue int default 0, mytime TIMESTAMP } INSERT INTO mytable VALUES( 123, NULL ); -----Original Message----- From: *Himerus* [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 05, 2001 12:26 AM To: [EMAIL PROTECTED] Subject: help with timestamp... Can anyone give me a good link on how to put in a timestamp on a form that inserts directly into a sql database??? I keep trying it, but it's only coming thru as 00000000000000 , so on. Thanks. Newbie Jake. --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php