Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2003
    Location
    AU
    Posts
    19

    Question Unanswered: epoch time vs oracle time

    I'd like to know what advantages there are for using different time formats?

    I am currently redeveloping an old database and the date/times can be found in Julian, Epoch, and YYYYDOY formats. Should I convert all to Oracle date/time?

    If so, which oracle format and how much accuracy do these have?

  2. #2
    Join Date
    Dec 2002
    Location
    Netherlands
    Posts
    118
    Hi

    In 8i you have accurancy in seconds
    In 9i you have accurancy in milliseconds


    Remi
    Remi Visser

    Oracle Database Administrator
    (OCP certified 8i)

    Homepage: http://home.remidian.com/

  3. #3
    Join Date
    Sep 2002
    Location
    UK
    Posts
    5,171
    Provided Answers: 1

    Re: epoch time vs oracle time

    Originally posted by calico
    I'd like to know what advantages there are for using different time formats?

    I am currently redeveloping an old database and the date/times can be found in Julian, Epoch, and YYYYDOY formats. Should I convert all to Oracle date/time?

    If so, which oracle format and how much accuracy do these have?
    I would definitely recommend changing these various formats to the Oracle DATE format - or TIMESTAMP if sub-second accuracy is required. Then you will be able to perform date arithmetic easily and consistently.

    If you have any legacy code that requires seeing the dates in some particular format, you can give it a view that provides the required format, either through TO_CHAR and a format mask, or via a bespoke function.

Posting Permissions

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