Day From Date

Gotcha: TO_CHAR right-pads to 9 in length

This won't work:

to_char(event_date,'Day') = 'Monday'

But any of these will:

1. TO_CHAR(event_date,'Day') = 'Monday   '

2. RTRIM(TO_CHAR(event_date,'Day'),' ')  = 'Monday   '

3. TO_CHAR(event_date,'FMDay') = 'Monday'