This content has been marked as final. Show 4 replies
It appears that your research lead you to a SQL Server thread. SQL Server uses arbitrary numbers to represent date formats. Oracle does not-- the number 112 has no relevance to Oracle.
In Oracle, you convert a date to a string using the TO_CHAR function
Of course, that assumes that you are starting with a date (as I do with my date literal). If you are starting with a string that represents a date and you want to convert it to a string that represents that same date in a different format, you would need to use both a TO_DATE and a TO_CHAR to convert the original string to a date and the date to a different string
SELECT to_char( date '2012-11-19', 'YYYYMMDD' ) FROM dual
SELECT to_char( to_date( '19 Nov 2012', 'DD Mon YYYY' ), 'YYYYMMDD' ) FROM dual