Netezza / PureData – Now() Command For Current Date

PureData Analytics Now() Command
PureData Analytics Now() Command

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.

Example SQL

Select now() as “Today”

from _V_DUAL;

Related Reference

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

Netezza / PureData – Current Date Function

Netezza, PureData, Current Date Function, CURRENT_DATE
Puredata Analytics Current Date Function

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 the current date via SQL.

Example SQL

Select current_date as “Today”

from _V_DUAL;

Related Reference

Functions

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