DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: milliseconds in oracle

  1. #1
    Join Date
    Aug 2001
    Location
    bangalore,india
    Posts
    17

    Red face

    hi..guys
    can we track milliseconds in oracle(it is possible in mssql)
    if yes how,if no then oracle is not useful when milliseconds come into picture

  2. #2
    Join Date
    Nov 2001
    Location
    Turkey
    Posts
    7
    Hi,

    You can use dbms_utility.get_time or query from v$timer synonym
    to get time in milliseconds. This is for calculating time
    difference. Date field is stored upto the precision of second.

    In Oracle 9i is possible another way.

    hop this helps.

    Regards

  3. #3
    Join Date
    Oct 2001
    Posts
    83
    Hello,

    In Oracle 9i, a new datatype by the name of : TIMESTAMP gives date&time with miliseconds (fractional seconds).

    Best Regards

  4. #4
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    Originally posted by noor
    Hello,

    In Oracle 9i, a new datatype by the name of : TIMESTAMP gives date&time with miliseconds (fractional seconds).

    Best Regards
    There are 5 new data types:

    TIMESTAMP
    TIMESTAMP WITH TIME ZONE
    TIMESTAMP WITH LOCAL TIME ZONE
    INTERVAL YEAR TO MONTH
    INTERVAL DAY TO SECOND



Posting Permissions

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


Click Here to Expand Forum to Full Width