Difference Between to_char and to_date with example
to_char:
to_char converts a date to string.
Query:
Select to_char(sysdate) from dual;
Output:
25-NOV-13
Query:
Select to_char(sysdate,’DD-MM-YYYY’) from dual;
Output:
25-11-2013
to_date:
to_date converts a string to date.
Query:
Select to_date(sysdate) from dual;
Output:
25-NOV-13
Query:
Select to_date(sysdate,’DD-MM-YYYY’) from dual;
Output:
25-NOV-13