Results 1 to 4 of 4
  1. #1
    Join Date
    Aug 2004
    Posts
    8

    Talking Unanswered: time in millisecond

    Is there any way in Oracle to display time in millisecond ?

  2. #2
    Join Date
    Jun 2004
    Location
    Liverpool, NY USA
    Posts
    2,509
    This is a sort of good news bad news. In Oracle 9i and above, you can use the timestamp data element instead of date. Date only goes to seconds, timestamp goes to milliseconds.
    Last edited by beilstwh; 08-30-04 at 16:16.
    Bill
    You do not need a parachute to skydive. You only need a parachute to skydive twice.

  3. #3
    Join Date
    Jun 2003
    Location
    Ottawa
    Posts
    105

    sure...

    oracle displays differences in time in days...so, to do so in milliseconds (1000th of a second)....

    divide by 24 (hours in a day)
    divide by 60 (minutes in an hour)
    divide by 60 (seconds in a minute)
    divided by 1000 (milli seconds in a second)

    select ((((((<later_time>) - <earlier_time>) / 24) / 60) / 60) / 1000) from <table>;

  4. #4
    Join Date
    Jan 2004
    Location
    Germantown, MD
    Posts
    34
    You can do it using java or C... Go here to find out how:
    http://asktom.oracle.com/pls/ask/f?p...:341817437103,
    "The world is a dangerous place, not because of those who do evil, but because of those who look on and do nothing. "
    - Albert Einstein

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •