Originally posted by bigpomp81
... TO_DATE(SYSDATE, 'DD-MM-YYYY') ...
SysDate is a date already, by the way. Don't convert it to a character string.