1.

How Will You Convert A Date To Char In Oracle Give One Example

Answer»

to_char() FUNCTION is used to CONVERT DATE to character we can specify format also in which we WANT the output.

SELECT to_char( to_date('11-01-2012', 'DD-MM-YYYY') , 'YYYY-MM-DD') FROM dual;
or
SELECT to_char( to_date('11-01-2012, 'DD-MM-YYYY') , 'DD-MM-YYYY') FROM dual;

to_char() function is used to convert date to character we can specify format also in which we want the output.

SELECT to_char( to_date('11-01-2012', 'DD-MM-YYYY') , 'YYYY-MM-DD') FROM dual;
or
SELECT to_char( to_date('11-01-2012, 'DD-MM-YYYY') , 'DD-MM-YYYY') FROM dual;


Discussion

No Comment Found

Related InterviewSolutions