There is more than one way to retrieve current date information from PureData Analytics (Netezza).  Using the Now() function is easy to retrieve the current date from within SQL.

Example SQL

Select now() as “Today”

from _V_DUAL;

Date/time functions

PureData System for Analytics, PureData System for Analytics 7.1.0, IBM Netezza Database User’s Guide, Netezza SQL basics, Netezza SQL extensions, Date/time functions

• https://www.ibm.com/support/knowledgecenter/SSULQD_7.1.0/com.ibm.nz.dbu.doc/r_dbuser_ntz_sql_extns_date_time_funcs.html