Time precision

From: <StevenHaas_at_ebico.com>
Date: Tue, 27 Jun 2000 08:23:30 -0400
Message-Id: <10541.110522@fatcity.com>

Good Morning,

I have been asked if a date/time down to the microsecond as stored in DB2 can be stored in Oracle with the same precision.

My gut feeling is that it can but I would like a confirmation (one way or the other) from the list.

How precise is the date datatype?

If so how can it be displayed to show the precision?

Oracle Env't: Oracle 8.1.5, HP-UX 11.0 (64 bit)

TIA, Steve Haas
DBA Consultant
@ Royal & SunAlliance
steven_haas_at_rsausa.com
opusllc_at_email.com

"Opinions expressed, right or wrong, are my own." Received on Tue Jun 27 2000 - 07:23:30 CDT