SYSDATE

[arpan]

How do I get only the DAY part or the MONTH part or the YEAR part using SYSDATE from the table DUAL? For e.g. if the SYSDATE is 26-FEB-03, then what function do I use so that DAY=26, MONTH=FEB (or 02 or simply 2) & YEAR=03 (or 2003)?

Thanks,

Arpan

 

[Mockenrue]

select to_char(SYSDATE,'DD') from dual;

select to_char(SYSDATE,'YYYY') from dual;