search date in oracle sql code example

Example: oracle search in date columns

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