Monthly Archives: February 2013

Return all monday between two dates – using Oracle sql

Return all Monday between two dates – using Oracle sql Query select to_date (’2012-12-30′, ‘yyyy-mm-dd’) + (level – 1) as Date from dual where to_char(to_date(’2012-12-30′, ‘yyyy-mm-dd’) + level – 1, ‘DY’) = ‘MON’ connect by level <= ceil( (to_date(’04-Jan-2014′,’dd-mon-yyyy’) – to_date(’30-dec-2012′,’dd-mon-yyyy’))+1 ) order by Date ; For Example if my start date is 01/01/2013 and… Read More »