datetime timestamp, and utc date
Posted by: David Thielen
Date: November 14, 2006 03:49PM

Hi;

I am porting from a SqlServer database and trying to create a .sql file to create the database and tables for the database. I am tripping over two things.

1) I have a column that needs to be set to the UTC datetime of when the row is created. The following is not working:
rCreated DATETIME NOT NULL DEFAULT UTC_TIMESTAMP,

2) I have a column who's value needs to be changed automatically every time a row is created/updated. I am assuming the TIMESTAMP type does this. Is this correct? And does this happen automatically or do I need to do something?

thanks - dave

Options: ReplyQuote


Subject
Written By
Posted
datetime timestamp, and utc date
November 14, 2006 03:49PM


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.