Tuesday, August 25, 2009

How to get the current system date in Oracle?


Getting the current system date:

SQL> select sysdate from dual;

How to find the day of the month:

SQL> select extract(day from sysdate) from dual;

You can also say extract month and year the same way.
Give it a try.