O'Reilly logo

Netezza SQL by Mike Larkins, Tom Coffing

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 7 – Date Functions

"An inch of time cannot be bought with an inch of gold."

Chinese Proverb

Date, Time, and Timestamp Keywords

SELECT Current_Date            AS ANSI_Date

,Current_Time           AS ANSI_Time

,Current_Timestamp  AS ANSI_Timestamp ;

image

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required