Re: TO_DATE

Sybrand Bakker wrote:

> Oracle doesn't capture fractions of a second, so the answer is no, you can't
> do that.

Not exactly.....
For Oracle 8 use dbms_utility package
 function get_time return number;

• Find out the current time in 100th's of a second.
• Output arguments:
• get_time
• The time is the number of 100th's of a second from some
• arbitrary epoch.

>
> Sorry,
> Sybrand Bakker, Oracle DBA

For Oracle 8 use dbms_utility package
 function get_time return number;

• Find out the current time in 100th's of a second.
• Output arguments:
• get_time
• The time is the number of 100th's of a second from some
• arbitrary epoch.

Maxim Sokolnikov Oracle DBA Received on Thu Mar 30 2000 - 00:00:00 CST