Retrieving last monday but no data in result set <p>I am trying to retrieve last monday when given date is monday below is the code.</p> <pre><code>select Case when to_char(to_date('21/10/2013','dd/mm/yyyy'), 'DAY') = 'MONDAY' then to_date(next_day(to_date('21/10/2013','dd/mm/yyyy')-7,'Tuesday') - 1, 'dd/mm/yyyy') END from dual </code></pre> <p>Query is executing and result is one record but record is totally empty.</p> <p>I am confused why there is no data in the result set.</p> <p>Please help me in resolving this.</p>