Blog » Print » Oracle Sysdate formatting

Oracle Sysdate formatting

Posted By Bennett On 23. May 2008 @ 15:07 In SQL | No Comments

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;

Article printed from Blog: http://blog.bennett-scharf.com

URL to article: http://blog.bennett-scharf.com/2008/05/23/oracle-sysdate-formatting/

Click here to print.