Re: DATETIME suppport?

Hi,
Dates are times and dates. You cannot (in Oracle) differenciate between time and dates. They are both present in the same type. In other words you cannot have a time without a date ... and you cannot have a date without a time.

Normally the granuality of dates are seconds - that's correct. But from PL/SQL you can refer down to hundreds of a second.

I think you're from the DB2 world ... Oracle doesn't use Timestamps as DB2 does ... instead you'll use a sequence to identify individual transactions.

Hope this helps .....

• Peter H. Larsen Oracle Consultant

Roger Tomas wrote:
>
> Was just perusing some online Oracle documents and
> did not see any mention of TIME, TIMESTAMP or
> INTERVAL data types - only DATE. Does Oracle
> not support these?
>
> Also, does Oracle offer fractions of a second precision?
> I only saw mention of DATEs going down to the second.
>
> Roger Tomas
> AG Communication Systems

--

Peter H. Larsen, Oracle and Applications specialist Dynamic Resources Inc, Alexandria
Phone: 703-914-9800 #103
Fax: 703-914-9804
Email: plarsen_at_dc.dynares.com
(please remove the nospam from the header when replying to this email)

The above views are my own and does not reflect the views of my employer. Received on Tue Jul 07 1998 - 14:10:22 CDT