Oracle timestamp

Thread view:

worzel - 03 Jan 2005 08:18 GMT

In Oracle, what is the best way to do an auto generated timestamp? I dont
want to do it this in java application code.
TIA

Reply to this Message

EricF - 04 Jan 2005 05:18 GMT

>In Oracle, what is the best way to do an auto generated timestamp? I dont
>want to do it this in java application code.
>TIA

I'm not usually fond of database triggers but for generating a timestamp
automatically, that's the best way to go.

Eric

Reply to this Message

worzel - 04 Jan 2005 05:40 GMT

seriously? The supposedly biggest and best database on the planet, and you
cant do a timestamp without resorting to a database specific trigger!

Somebody just pointed me to an oracle' currentTimestamp()' function that I
may be able to use as the default for a column - here's hoping. (Not even
sure if you can use a function as a default column value - soon find out I
guess)

>>In Oracle, what is the best way to do an auto generated timestamp? I dont
>>want to do it this in java application code.
[quoted text clipped - 4 lines]
>
> Eric

Reply to this Message

Tobias Besch - 04 Jan 2005 07:38 GMT

> In Oracle, what is the best way to do an auto generated timestamp? I

How about that:

Create table mytable (
-- ... other columns...
mycolumn Timestamp(9) Default SYSTIMESTAMP NOT NULL )

Reply to this Message

Oracle timestamp

Free Magazines