PureData / Netezza – What date/time ranges are supported by Netezza?
Here is a synopsis of the temporal ranges ( date, time, and timestamp), which Netezza / PureData supports.
Temporal Type |
Supported Ranges |
Size In Bytes |
Date | A month, day, and year. Values range from January 1, 0001, to December 31, 9999. | 4 bytes |
Time | An hour, minute, and second to six decimal places (microseconds). Values range from 00:00:00.000000 to 23:59:59.999999. | 8 bytes |
Related References
- PureData / Netezza – What date ranges are supported by Netezza?
- Netezza / PureData – How to calculate months between two dates
- Netezza /PureData Date Difference in Days SQL
- Netezza / PureData – SQL Cast Conversion to Integers
- Netezza / PureData – Two ways to get Numeric Day of Year
One thought on “PureData / Netezza – What date/time ranges are supported by Netezza?”