Originally posted by engiri
Pls try and feedback.
I have done more than fifty testing, when I had this problem, for me also the data is huge.
Yes dear, i guess adding 0 does the trick too. I tested
trunc(departure_date) only but after sometime it hanged, i dont know
if its just a coincidence only but when i change it to
trunc(departure_date+0) it runs smoothly