Mega Code Archive
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>