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.
>
>
