Netezza / PureData – Now() Command For Current Date

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