Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Timestamp of a record

Re: Timestamp of a record

From: Daniel Morgan <damorgan_at_x.washington.edu>
Date: Wed, 10 Dec 2003 08:43:30 -0800
Message-ID: <1071074643.721508@yasure>


NoName wrote:

>>nope, not unless you have added a column to track that.

>
>
> you mean, I can provide an
> ALTER TABLE table ADD <a column> TIMESTAMP DEFAULT SYSDATE
> statement, so every time a row is inserted, I get the exact moment...
>
> OK, that's a solution, thank you very much.
>
> Regards
>

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US