Pre Exam Test Practice (SSC | Banking | IAS | GATE | State Level | CLAT | Railways | Insurance | Teaching Exams | NDA | Defence | IES |State Exam )

Organizational Research By

Surprising Reserch Topic

Question:How will you convert a date to char in Oracle give one example


 Similar to previous Oracle Interview question, this is also one of the popular question in various Oracle Interviews. 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;
SELECT to_char( to_date('11-01-2012, 'DD-MM-YYYY') , 'DD-MM-YYYY') FROM dual;

asked Sep 13, 2013 in ORACLE by anonymous
edited Sep 12, 2013
0 votes

Related Hot Questions

Government Jobs Opening