"An inch of time cannot be bought with an inch of gold."
SELECT Current_Date AS ANSI_Date
,Current_Time AS ANSI_Time
,Current_Timestamp AS ANSI_Timestamp ;
Above are the keywords you can utilize to get the date, time, or timestamp. These are reserved words that the system will deliver to you when requested. Netezza has a variety of date, time, and timestamp functions. Many of these are ANSI standard, and there are also some extensions that are unique to Netezza.
Along with the functions, there are corresponding DATE, TIME, and TIMESTAMP data types ...