For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!
Hi,
I want to fetch my result set in the format dd-mm-yyyy:hh24:mi:ss.
select to_date(sysdate,'dd-mm-yyyy:hh24:mi:ss')-to_date('24-NOV-13 15:54:24','dd-mm-yyyy:hh24:mi:ss') from dual;
there is no datediff function in oracle.
Thanks.