owen commented: TRUNC is not all bad it does have a purpose when used. It takes off the time part of the date making the comparison a whole date without the time getting mixed in. Without trunc you would have to use '31-JAN-2015 23:59:59' to get the last hours included in the results. So don't go changing stuff that works without knowing the side-effects and testing. If it aint broke..... ... read 2 more