Re: how to store timestamp in oracle 8.1.7?

From: Rauf Sarwar <rs_arwar_at_hotmail.com>
Date: 25 Sep 2002 17:31:48 -0700
Message-ID: <92eeeff0.0209251631.51a62b90@posting.google.com>

davidchantf_at_hotmail.com (david chan) 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

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.

/Rauf Sarwar Received on Wed Sep 25 2002 - 19:31:48 CDT