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

Written By
June 08, 2006 04:56AM
June 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.