topic Oracle -> WHERE Clause -> Date Question in QlikView

Oracle -> WHERE Clause -> Date Question

btrompetter — Wed, 29 Apr 2009 19:58:29 GMT

Hello,

I want to query a table in QlikView with the following SQL Statement over an OLEDB Oracle connection:

SQL SELECT *
FROM "GLB_RPT"."SALES_TAG_SOR"
WHERE "SALES_TAG_SOR"."DATUM" >= '01.03.2009';

But I got all records.

How must the statement look like? Must I use to_date?

Thanks for help

Bastian

Wed, 29 Apr 2009 20:05:47 GMT

Bastian,

What is the native date format of DATUM in the database?

Reagrds,

Gordon

btrompetter — Wed, 29 Apr 2009 20:17:55 GMT

If I change it to

SQL SELECT *
FROM "GLB_RPT"."SALES_TAG_SOR"
where (DATUM) >= (to_date('01.03.2009','DD.MM.YYYY'));

it works

regards

Bastian

Anonymous — Wed, 29 Apr 2009 20:20:53 GMT

Bastian,

The safe way to get rid of this sort of problems is to use the preceeding load:


LOAD
...
WHERE "SALES_TAG_SOR"."DATUM" >= '01.03.2009' // if this is your format in QV
SQL SELECT *
FROM "GLB_RPT"."SALES_TAG_SOR";

Regards,
Michael