By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
1 rows affected
MY_DATE |
---|
11-may-2019 |
MY_DATE |
---|
may-11-2019 |
TO_CHAR(MY_DATE,'DDMONYYYY') |
---|
11may2019 |
TO_CHAR(MY_DATE,'DDYYYY-MM') |
---|
112019-05 |
1 rows affected
MY_DATE |
---|
11-may-2019 |
MY_DATE |
---|
may-11-2019 |
TO_CHAR(MY_DATE,'DDMONYYYY') |
---|
11may2019 |
TO_CHAR(MY_DATE,'DDYYYY-MM') |
---|
112019-05 |