Re: struggling newbie - datetime or timestamp problem

[robert_rowe]

Your easiest route would be to make createddate a DATETIME field and update it yourself
when you insert a record. You can then make updateddate a TIMESTAMP and let MySQL set it
to NOW() automatically for you by not specifying it in any of your insert or update
queries. If you made them both timestamps then both fields would get updated as the
record changes. Play with it some and you'll see how it behaves.