Oracle Sysdate formatting

You can use the PL-SQL to_char function to format the output of SYSDATE like this:

select to_char(sysdate,’DD/MM/YYYY HH24:MI:SS’) from dual;

This entry was posted in SQL. Bookmark the permalink.