A value for a date, time, or timestamp can be compared either with another value of the same data type, or with a string representation of that data type. All comparisons are chronological, that is to say, the farther a point in time is from January 1, 0001, the greater the value of that point in time.
Comparisons and string representations involving time values always include seconds. If the string representation omits seconds, zero seconds is implied.
Comparisons involving timestamp values are chronological without regard to representations that could possibly be considered equivalent. The following predicate is therefore true:
TIMESTAMP('1985-02-23-00.00.00') > '1985-02-22-24.00.00'
|
Copyright © 2014 CA.
All rights reserved.
|
|