Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2004
    Posts
    5

    Unanswered: Equivalent of Informix Datatype 'Interval'

    Please let me know what could be the equivalent of Informix datatype "INTERVAL" in Oracle.

  2. #2
    Join Date
    Mar 2004
    Location
    Netherlands
    Posts
    183
    Hi,

    I'm not an Oracle DBA, maybe you should ask this in the Oracle forum. I know in the old days consultants for other database vendors used date fields and stored a date the interval higher as a fixed date (often 1-1-1980 00:00:00.00000). In the application they always made the calculation again.

    But as I said I don't know if the other vendors already created a similar approach as Informix.

    Rob

Posting Permissions

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