Not able to understand what this query is doing

Database

Not able to understand what this query is doing

Hi.

I am unable to understand this piece of code.

I googled about :END_DATE but nothing came up.

WHERE CAST( IDX.START_TXN_DATE AS DATE) BETWEEN :END_DATE - (104*7)-6 AND :END_DATE
Tags (1)
1 REPLY
Teradata Employee

Re: Not able to understand what this query is doing

:END_DATE is a host variable. The value will be supplied as a parameter.