IsGreater (OraTimeStampTZ) Method

Applies To

Description

Checks if the OraTimeStampTZ object is greater than an argument.

Usage

isGreater = OraTimeStampTZObj.IsGreater value, format

Arguments

The arguments for the method are:

Arguments	Description
[`in`] `value`	A `Variant` of type `String`, `Date`, or `OraTimeStampTZ` object to be compared.
[`in`] [optional] `format`	Specifies the `TIMESTAMP` `WITH` `TIME` `ZONE` format string to be used to interpret a value when `value` is type `String`. If `format` is not specified, `value` is interpreted using the `Format` property of the current `OraTimeStampTZ` object.

Remarks

Returns a Boolean value: The value is True if the OraTimeStampTZ object is greater than the argument; otherwise, it is False. The IsGreater method only compares the UTC date-time values stored in the OraTimeStampTZ object; the time zone information is ignored.

If value is of type String, the string format must match the format specified in the format argument. If format is not specified, the string format must match the Format property of the current OraTimeStampTZ object.

If value is of type Date, the date-time value in Date is interpreted as the date-time value in the time zone of the session.