Basic Date format

July 30, 2012 admin Oracle, Syntax

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

check_invalids.sql Finding Duplicate Entries