SYS_CALENDAR function in SQL Netezza

please

how can I run a query that generate a calendar in SQL Netezza like the below query that works with Teradata

SELECT *
   FROM SYS_CALENDAR.Calendar
   where calendar_date BETWEEN '2021-01-01' and current_date


Read more here: https://stackoverflow.com/questions/66303854/sys-calendar-function-in-sql-netezza

Content Attribution

This content was originally published by Ahmed Abdelkader at Recent Questions - Stack Overflow, and is syndicated here via their RSS feed. You can read the original post over there.

%d bloggers like this: