I was trying to the Oracle equivalent of TO_CHAR(<date field>, 'YYYYMMDD') as derived column in a Table using the GUI as well as Query table. However, I could not figure out how to do it.

Do we have an equivalent for TO_CHAR or Format command that converts data types from one form to another using format arguments?

Cheers

Sunil