CODE EXAMPLE FOR SQL

oracle search in date columns

select * from table
where es_date=TO_DATE('27-APR-12','dd-MON-yy')