Re: Timestamp of a record

From: Jeff Smith <jsmit234>
Date: Thu, 11 Dec 2003 07:23:09 -0500
Message-ID: <br9njd$dlc2@eccws12.dearborn.ford.com>

ALTER TABLE <table_name>
> ADD <column_name> TIMESTAMP DEFAULT SYSTIMESTAMP;

Is this something new? ... I am using 8.1.7

SQL> ALTER TABLE eraseme ADD (newcol1 TIMESTAMP DEFAULT SYSTIMESTAMP); ALTER TABLE eraseme ADD (newcol1 TIMESTAMP DEFAULT SYSTIMESTAMP)

                                                   *

ERROR at line 1:
ORA-00984: column not allowed here

I use:
alter table eraseme add( newcol date default sysdate) Table altered.

"Daniel Morgan" <damorgan_at_x.washington.edu> wrote in message news:1071074643.721508_at_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 Thu Dec 11 2003 - 06:23:09 CST