SQL query doesnt bring out results when queried using date

I see that a table has the data value as "18-May-2012". But when i query looking for the same date using the below query, no results are available.

Select Submit_Dt From Siebel.S_Order_Dtl
where submit_dt = '18-May-2012'

Could you pls help me sort this issue?