Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: how to store timestamp in oracle 8.1.7?
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