Explcit SQL Passthrough Teradata date question

ijm_wf — Wed, 28 Aug 2019 17:19:27 GMT

I am using a connect to Teradata statement within proc sql to do some explicit sql passthrough. I need help with the following Teradata select statement.

select * from ABC.TAB1 where cast((max(LD_DTTM)) as date) = current_date;

I keep getting a I keep getting an “Improper use of an aggregate function in a WHERE clause” error. LD_DTTM is a datetime(6) field and current_date is a date field.

Re: Explcit SQL Passthrough Teradata date question

LinusH — Thu, 29 Aug 2019 07:32:33 GMT

Since this is a Teradata specific SQL syntax question, I suggest that you seek help on a Teradata forum instead.

topic Explcit SQL Passthrough Teradata date question in ODS and Base Reporting

Explcit SQL Passthrough Teradata date question

Re: Explcit SQL Passthrough Teradata date question