The isValidTimestamp() function
Verifies whether a decoded m/d/y, h:m:s:micros Timestamp value is valid and within the Netezza Performance Server Timestamp range.
Description
The function
has the following syntax:
inline bool isValidTimestamp(uint32 month, uint32 day, uint32 year,
uint32 hour, uint32 minute, uint32 second, uint32 mcrs)
month specifies the month in the range of 1 (January) to 12 (December) inclusive.
day specifies the day in the range of 1 to 31 inclusive.
year specifies the year of the date in the range of SQL_YEAR_MIN to SQL_YEAR_MAX inclusive.
hour specifies the hour in the range of 0 to 23 inclusive.
minute specifies the minute in the range of 0 to 59 inclusive.
second specifies the second in the range of 0 to 59 inclusive.
mcrs specifies the microsecond in the range of 0 to 999999 inclusive.
Returns
False if isValidDate(month, day, year) is false or isValidTime(hour, minute, second, mcrs) is false.
Otherwise, the function returns true.