Search This Blog

Saturday, May 15, 2010

Get current day , month, year Oracle

Oracle > Date Time > Get current day , month, year Oracle


select to_number(to_char(sysdate,'dd')) day,to_number(to_char(sysdate,'mm')) month,to_number(to_char(sysdate,'yyyy')) year from dual;