Solved

Milliseconds

Posted on 1998-11-12
3
1,802 Views
Last Modified: 2011-09-20
Is there any way to display milliseconds using oracle functions. If so please explain in detail
0
Comment
Question by:mahh
  • 2
3 Comments
 
LVL 3

Accepted Solution

by:
poncejua earned 20 total points
ID: 1082529
Unfortunately there isn't an user/oracle function to display milliseconds. But there is a function in the DBMS_UTIL package which allow you to see the time in hundreds of seconds. The function name is get_time.

To explain with more detail I need to know what kind of use are you thinking for milliseconds (i.e. get the current time, update a field, etc.).
 
 
 
   
 

0
 

Author Comment

by:mahh
ID: 1082530
You are right. Let me explain I need to display time in my forms menu to as there are many updates per second and therefore milliseconds is only way to keep track of.
0
 
LVL 3

Expert Comment

by:poncejua
ID: 1082531
Why don't you try to develop a trigger in the tables involved on your "updates" ?

There you can use the dbms_util.get_time function.
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Have you ever had to make fundamental changes to a table in Oracle, but haven't been able to get any downtime?  I'm talking things like: * Dropping columns * Shrinking allocated space * Removing chained blocks and restoring the PCTFREE * Re-or…
Configuring and using Oracle Database Gateway for ODBC Introduction First, a brief summary of what a Database Gateway is.  A Gateway is a set of driver agents and configurations that allow an Oracle database to communicate with other platforms…
This video explains at a high level with the mandatory Oracle Memory processes are as well as touching on some of the more common optional ones.
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.

930 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now