Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1854
  • Last Modified:

Milliseconds

Is there any way to display milliseconds using oracle functions. If so please explain in detail
0
mahh
Asked:
mahh
  • 2
1 Solution
 
poncejuaCommented:
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
 
mahhAuthor Commented:
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
 
poncejuaCommented:
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

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now