O'Reilly logo

Tera-Tom Genius Series - Oracle SQL by Leona Coffing, 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 5 – Date Functions

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

- Chinese Proverb

Getting the System Date

image

The example above shows you how to get the system date. You must use the keyword sysdate and you need to get if from dual. Dual is a special table with a column called DUMMY that has a value of ‘X’. This 'X' column is used in selecting pseudo columns like SYSDATE.

Extracting the Day, Month, Year From the SYSDATE

image

Above are the keywords you can utilize to extract the day, month and year from the SYSDATE.

The Current_Timestamp ...

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