This content has been marked as final. Show 2 replies
How are you executing the query in Visual Studio? Do you have a query & some code?
The query is executed by SQL Server Integration Services, so no need for me to write any code. The query was a basic
I did get it fixed by using
SELECT CAN_ID, to_char(CAN_BIRTHDAY, 'DD/MM/YYYY') FROM SYSTEM.CANDIDATES
which would return the correct century.
SELECT CAN_ID, TO_DATE(CAN_BIRTHDAY, 'DD/MM/RRRR') FROM SYSTEM.CANDIDATES