Class IOracleIntervalDayToSecond

JavaScript API for Oracle type INTERVAL DAY TO SECOND.

Hierarchy

IOracleIntervalDayToSecond

Index

Constructors

Methods

add compare divide fromNumberOfDays fromString fromTimeZone getDays getHours getMinutes getSeconds multiply subtract toString toStringWithPrecision

Constructors

constructor

new IOracleIntervalDayToSecond(dy: number, hr: number, mm: number, ss: number, fs: number): IOracleIntervalDayToSecond
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

add

add(summand: IOracleIntervalDayToSecond): IOracleIntervalDayToSecond
Adds the interval to another interval and returns the resulting interval

Returns
the resulting interval as IOracleIntervalDayToSecond
Parameters
- summand: IOracleIntervalDayToSecond
  
  the other interval
Returns IOracleIntervalDayToSecond

compare

compare(i1: IOracleIntervalDayToSecond, i2: IOracleIntervalDayToSecond): any
Compares two intervals. Returns -1 if i1 < i2, 0 if they are equal, and 1 if i1 > i2.

Returns
the result of the comparison as a number between -1 and +1.
Parameters
- i1: IOracleIntervalDayToSecond
  
  first interval to use for the comparison
- i2: IOracleIntervalDayToSecond
  
  second interval to use for the comparison
Returns any

divide

divide(divisor: number | OracleNumber): IOracleIntervalDayToSecond
Divides the interval by an Oracle number or JavaScript number and returns the resulting interval

Returns
the resulting interval
Parameters
- divisor: number | OracleNumber
  
  the divisor used in the division
Returns IOracleIntervalDayToSecond

fromNumberOfDays

fromNumberOfDays(days: number | OracleNumber): IOracleIntervalDayToSecond
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
- days: number | OracleNumber
  
  number of days
Returns IOracleIntervalDayToSecond

fromString

fromString(interval: string): 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

fromTimeZone

fromTimeZone(tz: string): 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

getDays

getDays(): number
Returns the number of days from the interval

Returns
the number of days from the interval

Returns number

getHours

getHours(): number
Returns the number of hours from the interval

Returns
the number of hours from the interval

Returns number

getMinutes

getMinutes(): number
Returns the number of minutes from the interval

Returns
the number of minutes from the interval

Returns number

getSeconds

getSeconds(): 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

multiply

multiply(factor: number | OracleNumber): IOracleIntervalDayToSecond
Multiplies the interval with an Oracle number or a JavaScript number and returns the resulting interval

Returns
the resulting interval
Parameters
- factor: number | OracleNumber
  
  the factor used in the multiplication
Returns IOracleIntervalDayToSecond

subtract

subtract(subtrahend: IOracleIntervalDayToSecond): IOracleIntervalDayToSecond
Subtracts another interval from the interval and returns the resulting interval

Returns
the resulting interval as IOracleIntervalDayToSecond
Parameters
- subtrahend: IOracleIntervalDayToSecond
  
  the other interval
Returns IOracleIntervalDayToSecond

toString

toString(): string
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

toStringWithPrecision

toStringWithPrecision(daysPrecision: number, fractionalSecondsPrecision: number): 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

Class IOracleIntervalDayToSecond

Hierarchy

Index

Constructors

Methods

Constructors

constructor

Returns

Parameters

dy: number

hr: number

mm: number

ss: number

fs: number

Returns IOracleIntervalDayToSecond

Methods

add

Returns

Parameters

summand: IOracleIntervalDayToSecond

Returns IOracleIntervalDayToSecond

compare

Returns

Parameters

i1: IOracleIntervalDayToSecond

i2: IOracleIntervalDayToSecond

Returns any

divide

Returns

Parameters

divisor: number | OracleNumber

Returns IOracleIntervalDayToSecond

fromNumberOfDays

Returns

Parameters

days: number | OracleNumber

Returns IOracleIntervalDayToSecond

fromString

Returns

Parameters

interval: string

Returns IOracleIntervalDayToSecond

fromTimeZone

Returns

Parameters

tz: string

Returns IOracleIntervalDayToSecond

getDays

Returns

Returns number

getHours

Returns

Returns number

getMinutes

Returns

Returns number

getSeconds

Returns

Returns number

multiply

Returns

Parameters

factor: number | OracleNumber

Returns IOracleIntervalDayToSecond

subtract

Returns

Parameters

subtrahend: IOracleIntervalDayToSecond

Returns IOracleIntervalDayToSecond

toString

Returns

Returns string

toStringWithPrecision

Returns

Parameters

daysPrecision: number

fractionalSecondsPrecision: number

Returns string

Settings

Member Visibility