Re: Can you store 1/10th of a second in a DATE field?

From: Marty Himmelstein <marty.himmelstein_at_valley.net>
Date: 1995/07/28
Message-ID: <3v9fn0$ql3_at_dartvax.dartmouth.edu>#1/1

The dynamic performance table V$Timer has a single number column that is the current time in hundredths of a second. It does seem that the DATE datatype is weak on operations like time2 - time1 if the difference is less than a day, (5 minutes for example). I've played around a bit with this, but haven't had any luck.

Hope this helps.

Marty Himmelstein
marty.himmelstein_at_valley.net Received on Fri Jul 28 1995 - 00:00:00 CEST

This message: [ Message body ]
Next message: Kasten10: "Re: Windows freezing during SQL*PLUS execution."
Previous message: matthew_at_pobox.com: "Oracle Workgroup Server - how to run?"
In reply to: Srinivas Gollapudi: "Can you store 1/10th of a second in a DATE field?"
Next in thread: Kasten10: "Re: Windows freezing during SQL*PLUS execution."

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message