I almost touch on this question in a previous post, but neglected to answer the question directly. So, here is a table of the valid value range for a PureData / Netezza date field.
Valid date ranges for PureData / Netezza
| Field data Type | Storage Data Type | Minimum Valid Value | Minimum Value Shown as a Date | Maximum Valid Value | Maximum Value Shown as a Date | Disk Usage |
| Date | numeric(8,0) | -730119 | 0001-01-01 00:00:00 | 2921939 | 9999-12-31 00:00:00 | 4 |
Related reference
- Netezza / PureData – ERROR [HY000] ERROR: Bad timestamp external representation ‘0000-00-00’
- PureData – Current Date Function
- Netezza / PureData – how to convert an integer to a date
- Netezza/PureData SQL Date Formatting Examples
- PureData – Now() Command For Current Date
