Range specifier constants
The following table describes the range specifier constants. You can use these constants to represent the maximum or minimum values for the temporal fields. For a description of the meaning of the various Netezza Performance Server-encoded temporal data types, see Table 1.
| Constant | Description | Value |
|---|---|---|
| static const int32 ENC_DATE_MIN | The minimum value that the Netezza Performance Server-encoded Date can have. | -730,119 |
| static const int32 ENC_DATE_MAX | The maximum value that the Netezza Performance Server-encoded Date can have. | 2,921,939 |
| static const int64 ENC_TIME_MIN | The minimum value that the Netezza Performance Server-encoded Time can have. | 0 |
| static const int64 ENC_TIME_MAX | The maximum value that the Netezza Performance Server-encoded Time can have. | 86,399,999,999 |
| static const int32 ENC_TIMETZ_OFFSET_MIN | The minimum value that the Netezza Performance Server-encoded TimeTZ Offset part can have (+13:00:00). | -46800 |
| static const int32 ENC_TIMETZ_OFFSET_MAX | The maximum value that the Netezza Performance Server-encoded TimeTZ Offset part can have (-12:59:00). | 46740 |
| static const int64 ENC_TIMESTAMP_MIN | The minimum value that the Netezza Performance Server-encoded Timestamp can have. | -63,082,281,600,000,000 |
| static const int64 ENC_TIMESTAMP_MAX | The maximum value that the Netezza Performance Server-encoded Timestamp can have. | 252,455,615,999,999,999 |
| static const int32 ENC_INTERVAL_MONTH_MIN | The minimum value that the Netezza Performance Server-encoded Interval Month part can have. | -3,000,000 |
| static const int32 ENC_INTERVAL_MONTH_MAX | The maximum value that the Netezza Performance Server-encoded Interval Month part can have. | 3,000,000 |
| static const uint16 SQL_YEAR_MIN | The minimum value that the decoded Year can have. Does not apply to the 'years' value of Interval. | 1 |
| static const uint16 SQL_YEAR_MAX | The maximum value that the decoded Year can have. Does not apply to the 'years' value of Interval. | 9999 |
| static const int16 SQL_OFFSET_MIN | The minimum value that the decoded Time Zone Offset part can have (-12:59). | -779 |
| static const int16 SQL_OFFSET_MAX | The maximum value that the decoded Time Zone Offset part can have (+13:00). | 780 |
| static const int32 EPOCH_START_AS_DATE | The start of the time_t Epoch, represented as an NZ Date (1/1/1970). | -11,323 |
| static const int32 EPOCH_END_AS_DATE | The end of the time_t Epoch, represented as an NZ Date (1/19/2038). | 13,898 |
| static const int64 EPOCH_START_AS_TIMESTAMP | The start of the time_t Epoch, represented as an NZ Timestamp (00:00:00, 1/19/1970). | -946,684,800,000,000 |
| static const int64 EPOCH_END_AS_TIMESTAMP | The end of the time_t Epoch, represented as an NZ Timestamp (03:14:07.999999, 1/19/2038). | 1,200,798,847,999,999 |