Re: how to store timestamp in oracle 8.1.7?

From: Brian Peasland <oracle_dba_at_peasland.com>
Date: Thu, 26 Sep 2002 18:12:47 GMT
Message-ID: <3D934E1F.5307E05C@peasland.com>

> You cannot as a DATE datatype. Either you store it as a
> VARCHAR2/NUMBER or goto Oracle 9i which has a TIMESTAMP support.
>
> To generate a TIMESTAMP in 8.1.7 and store it as a VARCHAR2, Use
> java.sql.Timestamp interface via Oracle's Java cartridge.

Huh?????

The major difference between DATE and TIMESTAMP is that DATE stores day and time with a precision to the second. TIMESTAMP will let you store a much finer precision, i.e. fractions of a second (along with the date).

Why use VARCHAR2 and/or NUMBER to store dates and times? It's just too much work. And then you want to throw Java into the equation?!?!?

Cheers,
Brian Received on Thu Sep 26 2002 - 13:12:47 CDT