Standard Oracle String to Date conversion in Oracle SQL

Convert the string to Date
select TRUNC (fnd_conc_date.string_to_date ('2012-04-01')) from dual


Get Date format of a string
select fnd_conc_date.get_date_format('2012-04-01') from dual