Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Timestamp of a record
NoName wrote:
>>nope, not unless you have added a column to track that.
Actually you can't. SYSDATE is not a TIMESTAMP. Try this instead:
ALTER TABLE <table_name>
ADD <column_name> TIMESTAMP DEFAULT SYSTIMESTAMP;
It will work a lot better.
-- Daniel Morgan http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp damorgan_at_x.washington.edu (replace 'x' with a 'u' to reply)Received on Wed Dec 10 2003 - 10:43:30 CST
![]() |
![]() |