카테고리 없음
날짜 변환형식 추가
Lazineer
2012. 11. 24. 01:52
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 |
Record Count: 1; Execution Time: 1ms View Execution Plan link
| TO_CHAR(SYSDATE,'MONTH"OFTHE"DDTH') |
|---|
| november of the 23rd |
Record Count: 1; Execution Time: 1ms View Execution Plan link
| TO_CHAR(SYSDATE,'MONTH"OFTHE"DDSP') |
|---|
| november of the twenty-three |
Record Count: 1; Execution Time: 1ms View Execution Plan link
| TO_CHAR(SYSDATE,'MONTH"OFTHE"DDSPTH') |
|---|
| november of the twenty-third |
Record Count: 1; Execution Time: 1ms View Execution Plan link
| TO_CHAR(SYSDATE,'MONTH"OFTHE"DDTHSP') |
|---|
| november of the twenty-third |
Record Count: 1; Execution Time: 56ms View Execution Plan link