"An inch of time cannot be bought with an inch of gold."
- Chinese Proverb
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.
Above are the keywords you can utilize to extract the day, month and year from the SYSDATE.