Advertisements
IBM Netezza / IBM PureData for Analytics
Here are a few examples of how to add days to a date field in Netezza:
Add a day to a Date Field
- date(current_date + cast(‘1 days’ as interval)) as DATE_PLUS_1
Adding 3 Days to Current Date
- date(current_date + cast(‘3 days’ as interval)) as CURRENT_DATE_PLUS_3
6 thoughts on “Netezza/PureData – How to add days to a date field”