DB2 Date format in Select Query

How to convert 'dd-mon-yyyy' date format to db2 date format

Solution:

Syntax:

select to_Char(field name,'MM/DD/YYYY') from table name