DTS Oracle Date defaulting to 20xx when it shouldn't

[SteveMe]

I need help big time. The folowing syntax will create a result data field '09/10/2002' hopefully that brings back the right date. However I'm getting the day and month back perfectly as well as the last 2 digits in the year. The first 2 digits of the year is defaulting to 20xx. How can I stop this. My coding below has to use a decode function to not include a date that sql server would error on. Any help would be greatly appreciated. Thanks!


TO_DATE(decode(DATE_ENTRY_CREATED, TO_DATE('11/11/1111', 'MM/DD/YYYY'), NULL, DATE_ENTRY_CREATED))

 

[SQLBill]

I can't find TO_DATE or decode in the MS SQL Books Online nor in The GURUS GUIDE TO TRANSACT SQL. Someone in this forum might be able to help, but you might be better off posting in the ORACLE forum.

-SQLBill