Originally posted by kris123
By the way would the logic be the same if i use
trunc(departure_date) as against trunc(departure_date+0)? Why add 0
thanks
Pls try and feedback.
I have done more than fifty testing, when I had this problem, for me also the data is huge.