• 

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

Related References

• IBM PureData System for Analytics -SQL functions
• PureData – Now() Command For Current Date
• Netezza – How GET to Database UTC Offset With SQL
• Netezza/PureData SQL Date Formatting Example
• Netezza / PureData – CURRENT_TIMESTAMP Function