SYSDATE Function

Is a date function returns the current date

The default format is DD-MON-YY

If you want to select current date

Type

Select sysdate

From dual;

SYSDATE

---------

03-OCT-11

-----------------------------------------------------------

Dual is a dummy table. The dual table consists one column name DUMMY and one row containing the value X.