use if u want time with date

select to_char(sysdate,'dd-Mon-yyyy- hh24:mi:ss') from dual;