Adds an interval to the timestamp to obtain a new timestamp
the interval used to obtain the new timestamp
resulting timestamp
Convert to an OracleTimestamp that contains the local date/time of the IOracleTimestampTZ.
Convert this IOracleTimestampTZ to an IOracleTimestampTZ in the specified time zone. The time zone string has to contain either a time zone offset of the form '(+|-)HH:MM' or a time zone region name.
The function returns an error if the date lies in a DST transition period in the specified time zone and if the Oracle Database parameter ERROR_ON_OVERLAP_TIME is true for the current session.
The time zone string.
Gets the day component in the Gregorian calendar.
day component as number
Gets the fractional second component.
fractional second component as number
Gets the hour component.
hour component as number
Gets the minute component.
minute component as number
Gets the month component in the Gregorian calendar.
month component as number
Gets the second component.
second component as number
Gets the time zone of an IOracleTimestampTZ.
the time zone name as string
Gets the year component in the Gregorian calendar.
year component as number
Subtracts an interval from the timestamp to obtain a new timestamp
the interval used to obtain the new timestamp
resulting timestamp
Subtracts another timestamp from the timestamp to obtain a day-to-second interval.
the other timestamp used as subtrahend
year-to-month interval defined by the two timestamps
Subtracts another timestamp from the timestamp to obtain a year-to-month interval
the other timestamp used as subtrahend
year-to-month interval defined by the two timestamps
Converts the given datetime to a string in a given format. An optional datetime format model and an optional NLS parameter string can be provided. If no format model and/or no NLS parameter string is provided, the respective default values for the session are used.
If an NLS parameter string is specified, it has the effect of temporarily altering the session's NLS settings for the duration of the call to this method. The NLS parameter string may set the NLS_DATE_LANGUAGE parameter.
If a datetime format model is specified, it overrides the datetime format determined by NLS settings.
Optionalformat: stringdatetime format model
OptionalnlsParam: stringoptional NLS parameter string
a string of the timestamp
StaticcompareCompares two datetime values. Returns -1 if date1 < date2, 0 if they are equal, and 1 if date1 > date2.
the result of the comparison as a number between -1 and +1.
StaticfromParse a string into an IOracleTimestampTZ. An optional datetime format model and an optional NLS parameter string can be provided. If no format model is specified, the string must be in the default format for the Oracle TIMESTAMP WITH TIME ZONE data type, which is determined by the NLS_TIMESTAMP_TZ_FORMAT parameter.
If an NLS parameter string is specified, it has the effect of temporarily altering the session's NLS settings for the duration of the call to this method. The NLS parameter string may set the NLS_DATE_LANGUAGE parameter.
If a datetime format model is specified, it overrides the datetime format determined by NLS settings (i.e. the setting of the NLS_TIMESTAMP_TZ parameter).
The function returns an error if the specified date lies in a DST transition period and if the Oracle Database parameter ERROR_ON_OVERLAP_TIME is true for the current session.
date represented as a string
Optionalformat: stringoptional datetime format model
OptionalnlsParam: stringoptional NLS parameter string. Must have the same format as the NLS argument to the TO_TIMESTAMP_TZ SQL function.
an IOracleTimestampTZ object
JavaScript API for Oracle type TIMESTAMP WITH TIME ZONE.