Granularity of ORACLE's date/time

From: Karen Huguley <khuguley_at_sti.nasa.gov>
Date: 1995/05/11
Message-ID: <3otb0p$k3j_at_nova.sti.nasa.gov>#1/1

I apologize for the simplicity of this question, but I am surprised at what I am finding with ORACLE's sysdate function.

Is it possible to extract milliseconds from the system date/time? Seconds are not always granular-enough. Any suggestions?

Thanks in advance,
K. Huguley
NASA Center for AeroSpace Information Received on Thu May 11 1995 - 00:00:00 CEST

This message: [ Message body ]
Next message: Ian Bainbridge: "Re: Granularity of ORACLE's date/time"
Previous message: Perry McGrew: "RE: Delete UNIX files/tblsp owned by Oracle"
Next in thread: Ian Bainbridge: "Re: Granularity of ORACLE's date/time"
Reply: Ian Bainbridge: "Re: Granularity of ORACLE's date/time"
Reply: Jonathan Lewis: "Re: Granularity of ORACLE's date/time"
Reply: Vijay Nuthulapaty: "Re: Help SQLPlus"
Reply: Randy Dewoolfson: "Re: Granularity of ORACLE's date/time"
Maybe reply: James: "Re: Granularity of ORACLE's date/time"

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

Original text of this message