How can we convert a date to char in Oracle Please explain with Example

Answer 1

The best answer is:
to_ date function is used to convert string to a date function.

Syntax :  to_date(string, format)
Example:   to_date('2014/05/10', 'yyyy/mm/dd')  It will return May 10, 2014

Answer 2

Date Format:

SELECT GETDATE()

It will show the output 2014-11-17 15:26:19.580

Convert Date to Char:

  SELECT CONVERT(VARCHAR(15),GETDATE(),103)

It will show the output 17/11/2014