sql query not returns zero

[mkumarnk]

This offerdate's type is date or not.

Did u try in this way

trunc(offer.offerDate)>trunc(to_date('01/jan/00','dd/mon/yy').