There is more than one way to retrieve current date information from PureData Analytics (Netezza), using the Current_Date Function is an easy way to retrieve current date via SQL.
Select current_date as “Today”
- Netezza/PureData SQL Date Formatting Examples
- Netezza/PureData – How to add days to a date field
- PureData – Now() Command For Current Date