To_char Date format
I am using Oracle 10G.
when I am using the following sql query, it's returning me the desired output.
select to_char(sysdate,'MM/DD/YYYY HH24:MI:SS') as "Current Time"
from dual;But when I am changing 'SYSDATE' with some value it's throwing me the error - ORA - 01722 (Invalid Number).
select to_char('07/08/2012 23:05:00','MM/DD/YYYY HH24:MI:SS') as "Current Time"from dual;Please help me out.Thanks.