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

Home -> Community -> Usenet -> c.d.o.server -> Re: how to store timestamp in oracle 8.1.7?

Re: how to store timestamp in oracle 8.1.7?

From: Brian Peasland <oracle_dba_at_peasland.com>
Date: Wed, 25 Sep 2002 19:10:12 GMT
Message-ID: <3D920A14.C486E81@peasland.com>


Check out the DATE datatype. It stores data *and* time.

HTH,
Brian

david chan wrote:
>
> Hi,
> How can I store timestamp thing (not just yyyy-Mon-dd, but include
> time) to oracle 8.1.7? What kind of datatype it will be? (I know there
> are no timestamp datatype in 817, but in DB2 and oracle 9i) So how to
> make up this in 8.1.7?
> Thanks.
> David
Received on Wed Sep 25 2002 - 14:10:12 CDT

Original text of this message

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