Re: Automating Date in mySQL

On Sunday 03 February 2002 03:47, Todd Williamsen wrote: > I want the date to automatically be updated. So if a post was made on > 2/10/2001 I would like it to put it automatically in the database. > > I do have a column called "Date" and the datatype is set to date. But when > I add a record even if the sql states to insert the date it doesn't, or > does the date need to be manually added? Use a field of the type "Timestamp" -- it updates automatically whenever the record is updated. -- Jason Wong -> Gremlins Associates -> www.gremlins.com.hk /* The only difference in the game of love over the last few thousand years is that they've changed trumps from clubs to diamonds. -- The Indianapolis Star */