I think it's because you are converting Actual_End_date to UTC. Is "5/7/2006 1:49:16 AM" the value for Actual_End_date or for convert_utc_date(Actual_End_date,'MDT') ? If it's the value for Actual_End_date, then depending on the timezone of Actual_End_date it could be correct, could not it ? (Actual_End_date would be out of range, but convert_utc_date(Actual_End_date,'MDT') wouldn't).
HTH & Regards,
ORA-000TK : No bind variable detected... Shared Pool Alert code 5 - Nuclear query ready .
Thanks so much for the response because I really need the help on this. O.k your question "Is "5/7/2006 1:49:16 AM" the value for Actual_End_date". Yes it is the actual value. Is there a command to find the actual timezone in oracle for the Actual End Date. I'm getting confused on what UTC and MDT stands for. The function was in place before I started(convert_utc_date(Actual_End_date,'MDT') What is MDT? You could be right then because of what I am comparing. If Actual end date is in a different time zone then convert_utc_date(Actual_End_date,'MDT') then yes I would have a problem. Could you tell me how to check the time zone on the actual end date and what UTC and MDT stand for. Because, correct me if I am wrong, I would just need to change the MDT in the function to the time zone that Actual end date is referring to. Am I right. Your continued help is appreciated.
Damn, you guys are the smartest. O.k the clarification really helped not only understand the issue but what the function is actually doing. My system should be/is set to EST so inorder to fix this I substituted the MDT with EST and all is well. You guys are the experts and I really appreciate the quick replies. Thanks so much and have a great day.