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!
select to_char(to_timestamp(sysdate), 'DD-MON-YYY HH:MI') from dual;
gives me
13-MAR-015 12:00 as output
why is the time resetting to midnight?