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
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 Osborne wrote:
>>> Just add a field of type TIMESTAMP to your record. Whenever the field
>>> added or updated, this field will be updated as well.
>>> The field is already a 'timestamp(14)' type field, but all that is
>>> stored in the fields are zero's.
>>> Do you know what could be causing this?
>>> mysql (filter filter)
>> Yes, you are putting something there, and it is not a valid datetime,
>> so Mysql substitutes 0s.