Netezza/PureData – How to add days to a date field

Netezza/PureData – How to add days to a date field

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

Related References