DSXchange

Hi, I remember getting this error while using TO_DATE() in a stored procedure a while ago: "ORA-01841: (full) year must be between -4713 and +9999, and not be 0" The issue is because TO_DATE() expects to work on a CHARACTER data type and so there is an implicit conversion from DATE to CHAR...