SQL Date formatting function

TO_CHAR(date col­umn to for­mat , ‘DD-Mon-YYYY’) = ’10-May-2008’

THis func­tion comes handy to do quick date com­par­i­sions.