I am selecting some data from oracle table using user defined query through DRS stage. While selecting I am masking the date column with
Code: Select all
TO_CHAR(T1.IN_DT, 'YYYY-MM-DD HH24:MI:SS').
Code: Select all
If IsNull(LINK_In_Txn2.IN_DT) or " " Then "1900-01-01 00:00:00" Else LINK_In_Txn2.IN_DT
I see the date in correct format if i view data at source or run the query outside datasatge. However the same date is written into the output sequential file as 1900-01-01 00:00:00.
![Sad :(](./images/smilies/icon_sad.gif)
Can anybody give a clue as to what might be happening or what might be causing this.
Thanks.