There is more than one way to retrieve current date information from PureData Analytics (Netezza). Using the Now() command is an easy way to retrieve the current date from within SQL.
Select now() as “Today”
- PureData – Current Date Function
- Netezza/PureData SQL Date Formatting Examples
- Netezza/PureData – How to add days to a date field