ODI Error: " date format picture ends before converting entire input string"

 Hi,

This is a strange error I am getting in one of the ODI QA envs for date related variables. The Date related varibale is returning Date+Timestamp as it's o/p where as I am expecting only Date value. The Refresh query is working fine in DEV env but in QA env the date is also getting appended with timestamp.

ODI Refresh Query: SELECT TO_DATE('21000101','YYYYMMDD') FROM DUAL;

Values in QA env: "2100-01-01 00:00:00.0"  (This should have been ONLY "2100-01-01")

I tried all options but nothing worked out. Can anybody help on this..? Is this an ODI internal bug...?