Results 1 to 2 of 2

Thread: oracle timestamp arithmetic

  1. #1
    Join Date
    Jun 2005
    Posts
    1

    oracle timestamp arithmetic

    Hi

    I have a column in a table of type timestamp(6). I am trying to find the number of milliseconds between "now" as returned by localtimestamp and the timestamp in the table. Doing "SELECT (tabletimestamp - localtimestamp) FROM table" returns an interval type. Is there any way of getting the number of milliseconds directly from the interval type, or is it necessary to have a complex statement consisting of many EXTRACT statements?

    Any help would be appreciated.

    yod9999

  2. #2
    Join Date
    Mar 2003
    Posts
    468
    Here is an article I wrote that may help
    http://databasejournal.com/features/...le.php/2234501

Posting Permissions

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