sql query to convert date to mm/dd/yyyy hh:mi:ss format -oracle sql queries-to_char function

sql query to convert date to mm/dd/yyyy hh:mi:ss format




SELECT to_char(sysdate,'mm/dd/yyyy hh:mi:ss')Alias from dual;


output-


11/14/2012 07:56:29