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
Pingback: Netezza/PureData SQL Date Formatting Examples | Scientia Compendium
Pingback: PureData – CURRENT_TIMESTAMP Function | Scientia Compendium
Pingback: Netezza – Useful links | Scientia Compendium
Pingback: PureData – Current Date Function | Scientia Compendium
Pingback: PureData – Now() Command For Current Date | Scientia Compendium
Pingback: Infosphere Datastage – Useful Date Transformations | Scientia Compendium