Adds an interval to the timestamp to obtain a new timestamp
resulting timestamp
the interval used to obtain the new 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.
Compares 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.
Parse 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.
an IOracleTimestampTZ object
date represented as a string
Optional format: stringoptional datetime format model
Optional nlsParam: stringoptional NLS parameter string. Must have the same format as the NLS argument to the TO_TIMESTAMP_TZ SQL function.
Subtracts an interval from the timestamp to obtain a new timestamp
resulting timestamp
the interval used to obtain the new timestamp
Subtracts another timestamp from the timestamp to obtain a day-to-second interval.
year-to-month interval defined by the two timestamps
the other timestamp used as subtrahend
Subtracts another timestamp from the timestamp to obtain a year-to-month interval
year-to-month interval defined by the two timestamps
the other timestamp used as subtrahend
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.
a string of the timestamp
Optional format: stringdatetime format model
Optional nlsParam: stringoptional NLS parameter string
JavaScript API for Oracle type TIMESTAMP WITH TIME ZONE.