To_char(sysdate,DAY dy Dy) as day, to_char(sysdate,MONTH mon) as month
SQL> SQL> select to_char(sysdate,'DAY dy Dy') as day 2 , to_char(sysdate,'MONTH mon') as month 3 from dual; DAY MONTH --------------- ------------- MAANDAG ma Ma OKTOBER okt SQL> SQL>