SQL query to retrieve all days of the previous month

[bhaggyit]

Guys,
Could someone help me with SQL query to retrieve all days of the previous month?

Regards,
Bugs.

[JimKnicely]

Here is one solution:

Code: Select all

SELECT the_date
  FROM (SELECT ADD_MONTHS(DATE_TRUNC('MONTH', SYSDATE), -1) + (ROW_NUMBER() OVER () - 1) the_date
          FROM tables) foo
 WHERE the_date < DATE_TRUNC('MONTH', SYSDATE);