select to_char(SYSDATE, 'month "of the" dd') from dual;
select to_char(SYSDATE, 'month "of the" ddth') from dual;
select to_char(SYSDATE, 'month "of the" ddsp') from dual;
select to_char(SYSDATE, 'month "of the" ddspth') from dual;
select to_char(SYSDATE, 'month "of the" ddthsp') from dual;
| TO_CHAR(SYSDATE,'MONTH"OFTHE"DD') |
|---|
| november of the 23 |
| TO_CHAR(SYSDATE,'MONTH"OFTHE"DDTH') |
|---|
| november of the 23rd |
| TO_CHAR(SYSDATE,'MONTH"OFTHE"DDSP') |
|---|
| november of the twenty-three |
| TO_CHAR(SYSDATE,'MONTH"OFTHE"DDSPTH') |
|---|
| november of the twenty-third |
| TO_CHAR(SYSDATE,'MONTH"OFTHE"DDTHSP') |
|---|
| november of the twenty-third |