By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
BANNER |
---|
Oracle Database 11g Express Edition Release 11.2.0.2.0 - 64bit Production |
PL/SQL Release 11.2.0.2.0 - Production |
CORE 11.2.0.2.0 Production |
TNS for Linux: Version 11.2.0.2.0 - Production |
NLSRTL Version 11.2.0.2.0 - Production |
TO_DATE('01-02-2018','MM-DD-YYYY') | SUBSTR(TO_DATE('01-02-2018','MM-DD-YYYY'),4,3) |
---|---|
02-JAN-18 | JAN |