O'Reilly logo

Aster Data Database Administration by Todd Wilson, 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 19 – Time and Date

“To have everything is to possess nothing.”

-Buddha

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

Along with the functions, there are corresponding DATE, TIME, and TIMESTAMP data ...

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