You have not shown us what you are doing, only described it. Write a test case that creates a table with a timestamp field, populates the table, and does a select on it. Show us what you are doing, and the results.
Steve Osborne wrote: > I've tried passing nothing '' and NULL and 'NULL', and still the zero's. In > response to Mikel, the field is declared as NULL and default is NULL. I've > experimented with changing the Null and Default columns in phpMyAdmin, but > it stays as NULL and default as NULL. > > Steve. > >> Steve Osborne wrote: >> >>> Rick, >>> >>> <snip> >>> Just add a field of type TIMESTAMP to your record. Whenever the field >> > is > >>> added or updated, this field will be updated as well. >>> </snip> >>> >>> The field is already a 'timestamp(14)' type field, but all that is >> > being > >>> stored in the fields are zero's. >>> >>> Do you know what could be causing this? >>> >>> Steve >>> mysql (filter filter) >>> >> Yes, you are putting something there, and it is not a valid datetime, >> so Mysql substitutes 0s. > > --------------------------------------------------------------------- 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