Subject | Re: About the timestamp data type |
---|---|
Author | Adam |
Post date | 2006-01-23T23:36:09Z |
> if it's not what Adam says, then I would suspect that the queries ofthe
> second database is supplying a value for the field in question, whilethe
> qeries on the first database is not. Both table fields may have adefault
> NOW set but only the first db is getting that value since the field isThis is only an issue for insert statements. update statements do not
> omitted from the query.
touch fields that no value is supplied for, even if there is a default
value of now. (Defaults are only ever processed during inserts, and
only if you do not specifically name the field in your insert
statement). I am sure the cause will become clear though when they
investigate a bit further.
Adam