MLE PL/SQL Types(mle-js-plsqltypes)
    Preparing search index...

    Class IOracleIntervalDayToSecond

    JavaScript API for Oracle type INTERVAL DAY TO SECOND.

    Index

    Constructors

    • Constructor for IOracleIntervalDayToSecond using day, hour, minute, second, and fraction of a second. All arguments must be integral numbers.

      Parameters

      • dy: number

        number of days

      • hr: number

        number of hours

      • mm: number

        number of minutes

      • ss: number

        number of seconds

      • fs: number

        fractional seconds

      Returns IOracleIntervalDayToSecond

      new IOracleIntervalDayToSecond

    Methods

    • Returns the number of days from the interval

      Returns number

      the number of days from the interval

    • Returns the number of hours from the interval

      Returns number

      the number of hours from the interval

    • Returns the number of minutes from the interval

      Returns number

      the number of minutes from the interval

    • Returns the number of seconds including fractional seconds from the interval

      Returns number

      the number of seconds including fractional seconds from the interval

    • Produces a string representing the interval. The string is formatted with 2 digits for the number of days and 6 digits for the fractional seconds of the interval.

      Returns string

      a string representing the interval

    • Produces a string representing the interval. The string is formatted according to the specified precision for days and fractional seconds.

      Parameters

      • daysPrecision: number

        The number of digits used to represent days in the interval string.

      • fractionalSecondsPrecision: number

        Fractional second precision of the interval string (the number of digits used to represent the fractional seconds).

      Returns string

      a string representing the interval

    • Returns an IOracleIntervalDayToSecond for the given number of days. If the number of days contains a fractional part, the number of hours, minutes and seconds will be set accordingly.

      Parameters

      Returns IOracleIntervalDayToSecond

      new IOracleIntervalDayToSecond for the given number of days.

    • Parses an interval string into IOracleIntervalDayToSecond. This method accepts the same input formats as the Oracle SQL function TO_DSINTERVAL:

      • SQL interval format compatible with the SQL standard (ISO/IEC 9075)
      • ISO duration format compatible with the ISO 8601:2004 standard

      Parameters

      • interval: string

        string to parse.

      Returns IOracleIntervalDayToSecond

      new IOracleIntervalDayToSecond

    • Returns an IOracleIntervalDayToSecond for a given timezone offset or timezone name. The input string must be of the form [+/-]TZH:TZM or 'TZR'.

      Parameters

      • tz: string

        timezone offset or timezone name as string

      Returns IOracleIntervalDayToSecond

      new IOracleIntervalDayToSecond that contains the current absolute offset