SQL SELECT date from DB2

[Anonymous]

I do not understand why this isn't working.  I am trying to use SQL Select to read in a date field from a DB2 database.  The data is formatted as M/D/YYYY.  If I run this statement it pulls in everything.

SQL SELECT prd_dt

FROM table_A

But if I try to specify a date, it returns nothing:

SQL SELECT prd_dt

FROM table_A

WHERE date(prd_dt, 'M/D/YYYY') = '5/1/2016'

What am I missing here?  Thanks.

[boorgura · Accepted solution]

You cannot use Qlikview's Date function in the SQL statement - you will have to use DB2 syntax

for example

SQL SELECT ....

....

...

WHERE prd_dt = '2016-01-05'

(assuming that's your DB date format)

[Anonymous]

In my case the correct format was

prd_dt = '2016-05-01'

Thank you for your help!!   

[boorgura]

My pleasure! Happy to help.