Rabu, 11 Mei 2016

How to get all dates from sysdate's month (ORACLE)

SELECT to_char(day, 'dd') day
FROM
(
    SELECT TRUNC(SYSDATE, 'MM') + LEVEL - 1 AS day
    FROM dual
    CONNECT BY LEVEL <= 32
)
WHERE EXTRACT(MONTH FROM day) = EXTRACT(MONTH FROM SYSDATE) and day<=sysdate