Netezza / PureData Current Date Function

Advertisements

There is more than one way to retrieve current date information (Similar to the GETDATE() function) from PureData Analytics (Netezza), using the Current_Date Function is an easy way to retrieve the current date via SQL.

Puredata Analytics Current Date Function

Example SQL

Select current_date as “Today”

from _V_DUAL;

Related Reference

PureData System for Analytics, PureData System for Analytics 7.2.1, IBM Netezza database user documentation, Netezza, SQL command reference, Functions