#DateForumTypeThreadPost
118 Feb 2010 @ 06:57 PSTAnalyticsReplyCalendar table calculationQuick Example with the sys_calendar (Hope it helps):SELECT year_of_calendar, month_of_yearFROM sys_calendar.calendarWHERE calendar_date<=current_date AND EXTRACT(month FROM calendar_date)<...