Reply to Message

Some programmers using Oracle's PL/SQL languague use explicit strings for dates and when execute the code the dates are wrong because they forget that explicit date convertion are different on IDE (TOAD, DreamCoder, SQL*Plus, SQLTools, etc) that on the server where the Oracle instance are running.
I always recommend to use the function to convert string to dates (TO_DATE) and use the second parameter to format the string:
TO_DATE('2012-09-01','YYYY-MM-DD').