List:General Discussion« Previous MessageNext Message »
From:robert_rowe Date:January 5 2004 2:41pm
Subject:Re: struggling newbie - datetime or timestamp problem
View as plain text  
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.
Thread
struggling newbie - datetime or timestamp problemMatthew Stuart5 Jan
  • Re: struggling newbie - datetime or timestamp problemrobert_rowe5 Jan
  • Re: struggling newbie - datetime or timestamp problemAlec.Cawley5 Jan
  • RE: struggling newbie - datetime or timestamp problemLarry Brown5 Jan
  • Re: struggling newbie - datetime or timestamp problemTobias Asplund5 Jan