Hallo Denodo Team,
Investigating the reasons why a query is not delegated to the Teradata data source, we have read this explanation:
The function 'lastdayofmonth' cannot be delegated to this database
Teradata has a corresponding function, namely LAST_DAY
Why, in your opinion, the delegation does not happen? Is there a way to circumvent this (and similar) behaviour?
Thank you kindly
lastdayofmonth = addmonth(addday(current_date(), -1*extract(day from current_date())),1)