title: Query Oracle database for a specific Day
body: <p>I need to find all the events that happen on a certain day of the week  - say Wednesday.  I can convert my date field to display the day by using to_char(event_date, 'Day'), but when I put this in a where clause it doesn't return any results.</p>
  
  <p>For example:
  where to_char(event_date, 'Day') = 'Wednesday'</p>
  
  <p>I also tried this:
  select weekday from
  (select to_char(event_date, 'Day') "weekday" from Events)
  where weekday = 'Wednesday'</p>
  
  <p>Neither one returns any results.  Is there a way to accomplish this?</p>