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>
Related examples in the same category