select u.RECOMMAND_DATE from USERS u
where to_char(u.RECOMMAND_DATE,'yyyy-mm-dd') between '2009-05-21' and '2009-06-16' order by u.RECOMMAND_DATE desc
select u.RECOMMAND_DATE from USERS u
where to_char(u.RECOMMAND_DATE,'yyyy-mm-dd') between '2009-05-21' and '2009-06-16' order by u.RECOMMAND_DATE desc