Latest Activity


Return Data for the past months

Hi I'd like to query the teradata query in denodo VQL, however I cant able to get the syntax right. SELECT ADDMONTH(ADDMONTH(CURRENT_DATE, -12), (EXTRACT(MONTH FROM ADDDAY(<field_name> , -12 ) -6 ))) Any pointers would be appreciated. Thank you.

Date Conversion Dynamic Dates Date time function


Return Data for the past 6 months

Hi. I'd like to query the Denodo view via a querying tool (i.e. WinQSL) for the data from the last 6 months. I have tried the following, but I can't seem to get the Denodo syntax correct. select * from denodo_view where transaction_date >= getdate...

Date Conversion Dynamic Dates Dates Date


How to use dynamic dates in where clause

I am creating a view out of a Teradata database that has the date columns formated as YYYYMM and YYYY-MM-DD. Rather than a date WHERE condition based off of a static date such as '2019-10-31', I want a range based of a dynamics dates such as "ADD_MONTH...