Home » Blog Feed » All categories » Technology And Information Management » Databases And Data Virtualization » Netezza – Now() Function For Current Date

Netezza – Now() Function For Current Date

Bert SwopePosted oninAll categories, Databases And Data Virtualization, Netezza, Technology And Information Management6 Comments
Technology - Netezza Now() Function 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() 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

Pin
%d bloggers like this: