The Current_Timestamp function, returns the current date and time, from PureData Analytics (Netezza) and is an easy way to retrieve the current timestamp via SQL.

Example SQL

Select CURRENT_TIMESTAMP as “Current Time”

from _V_DUAL;

Related Reference

• IBM PureData System for Analytics -SQL functions
• PureData – Now() Command For Current Date
• Netezza – How GET to Database UTC Offset With SQL
• Netezza/PureData – How to add days to a date field
• Netezza/PureData SQL Date Formatting Example