Re: how to store timestamp in oracle 8.1.7?

From: Justin Cave <jocave_at_yahoo.com>
Date: 25 Sep 2002 15:29:01 -0700
Message-ID: <233b7a65.0209251429.6b750b19@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?

In Oracle 8.1.7, the date data type contains time with the resolution of 1 second. If you do

select <date_col> from table

in SQL*Plus, you probably don't see the date because your default date format is just to show the month, date, and year. Try

select to_char( <date_col>, 'DD/MM/YYYY HH:MI:SS' ) from table

in SQL*Plus, and you'll get the time. You could also alter your session to set the default date format to whatever you'd like.

Justin Received on Wed Sep 25 2002 - 17:29:01 CDT