Skip navigation links

MySQL Forums :: Database Design & Data Modelling :: Timestamp


Advanced Search

Timestamp
Posted by: flashster2003 ()
Date: June 08, 2006 04:56AM

I understood that simply creating two columns with a TIMESTAMP type when creating a new table, will result in the first column showing the update time and the second column show the created time.

I can't get it to work at all. All I get is the updated time in the first column - the second just ends up as 0000:00 etc.

I'm using 5.0.22.
I haven't altered the MaxDB setting from the default either.

Is there any way of doing this so I don't have to set the 2 values explicity every time I add/update a row?

Ideally I'd like to be able to do this from within DB Designer or workbench (i.e. from the GUI).

??

Options: ReplyQuote


Subject Written By Posted
Timestamp flashster2003 06/08/2006 04:56AM
Re: Timestamp Peter Brawley 06/08/2006 10:27AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.