Re: how to store timestamp in oracle 8.1.7?

On Thu, 26 Sep 2002 12:45:27 -0500, TurkBear <john.greco_at_dot.state.mn.us> wrote:

>
>Please IGNORE this poster is INCORRECT ; the Oracle DATE type is, in fact, a TIMESTAMP - it has date and time ( to the
>second) and you use it exactly like a timestamp as long as you enter the data correctly;;
<snip>

Except the OP specifically said he was looking for a TIMESTAMP like DB2 has. THAT timestamp resolves time to the millisecond, so while Ora 8x has a datatype that has both date and time components, it's NOT the same as DB2 TIMESTAMP.

--
Ed Stevens
(Opinions expressed do not necessarily represent those of my employer.)