Re: how to store timestamp in oracle 8.1.7?

From: Terry Dykstra <dontreply_tddykstra_at_forestoil.ca>
Date: Wed, 25 Sep 2002 19:07:01 GMT
Message-ID: <pPnk9.6$qB3.5244@news0.telusplanet.net>

Oracle date is a datetime. The time portion just doesn't have the same precision as the time type in 9i.

--
Terry Dykstra
Canadian Forest Oil Ltd.
"david chan" <davidchantf_at_hotmail.com> wrote in message
news:dca7348f.0209251053.1015d2e7_at_posting.google.com...


> 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:07:01 CDT