JavaScript API for Oracle type INTERVAL DAY TO SECOND.

Hierarchy

  • IOracleIntervalDayToSecond

Constructors

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

    Returns

    new IOracleIntervalDayToSecond

    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

Methods

  • 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.

    Returns

    new IOracleIntervalDayToSecond for the given number of days.

    Parameters

    Returns IOracleIntervalDayToSecond

  • 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

    Returns

    new IOracleIntervalDayToSecond

    Parameters

    • interval: string

      string to parse.

    Returns IOracleIntervalDayToSecond

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

    Returns

    new IOracleIntervalDayToSecond that contains the current absolute offset

    Parameters

    • tz: string

      timezone offset or timezone name as string

    Returns IOracleIntervalDayToSecond

  • Returns the number of days from the interval

    Returns

    the number of days from the interval

    Returns number

  • Returns the number of hours from the interval

    Returns

    the number of hours from the interval

    Returns number

  • Returns the number of minutes from the interval

    Returns

    the number of minutes from the interval

    Returns number

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

    Returns

    the number of seconds including fractional seconds from the interval

    Returns number

  • 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

    a string representing the interval

    Returns string

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

    Returns

    a string representing the interval

    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