List:General Discussion« Previous MessageNext Message »
From:Gerald Clark Date:December 14 2001 7:50pm
Subject:Re: Fw: timestamp
View as plain text  
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.
> 
> 

Thread
Fw: timestampSteve Osborne14 Dec
  • Re: Fw: timestampGerald Clark14 Dec
  • Re: Fw: timestampSteve Osborne14 Dec
  • Re: Fw: timestampGerald Clark14 Dec