Latest Activity

code

Lastdayofmonth for prior month is Denodo

Im trying ot get last day of the month with : LASTDAYOFMONTH(addmonth(current_date(),-1)). The above query gives result as : 2023-12-31 However when I run the same with few more lines of code: select field_name from "table_name" where "field_name" bet...

monthfunction dateformat

code

Denodo addmonth equivalent

Hi I have a teradata condition as: select (EXTRACT(MONTH FROM ADD_MONTH(DATE , 0) -6) FROM TABLE_NAME. what will be the equivalent of this query in denodo, as denodo is throwing error Thanks

Extra Functions monthfunction