Re: Fw: timestamp

[Gerald Clark]

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.