Daily Archive: March 31, 2012

Query SQL que devuelve todos los días de un determinado mes 6

Query SQL que devuelve todos los días de un determinado mes

SELECT TRUNC (SYSDATE, ‘MON’)+rownum-1 AS dias_del_mes FROM DUAL WHERE to_char(SYSDATE,’MON’)=to_char(TRUNC (SYSDATE, ‘MON’)+rownum-1,’MON’) CONNECT BY LEVEL <= 31SELECT TRUNC (SYSDATE, ‘MON’)+rownum-1 as dias_del_mes FROM DUAL where to_char(SYSDATE,’MON’)=to_char(TRUNC (SYSDATE, ‘MON’)+rownum-1,’MON’) CONNECT BY LEVEL <= 31 Lo...