Timestamp
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).
??
Subject
Written By
Posted
Timestamp
June 08, 2006 04:56AM
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.