topic sql stament with date filed in QlikView

sql stament with date filed

Fri, 06 Nov 2009 04:39:30 GMT

Hi Forum

I have a sql statement. I have problems with date field [doc-fec] . When I execute the script.

SQL SELECT emp-cod, doc-fec
FROM nom_historic
wHERE (cpt-liq = 105 Or cpt-liq =125) And emp-cod = '57147' And [doc-fec] >= '22/08/2009';

How can i apply this condition ?

Thanks.

sql stament with date filed

Oleg_Troyansky — Fri, 06 Nov 2009 06:18:11 GMT

it depends on your database and on the way the database stores dates. Your syntax needs to match your DB SQL syntax - the same way you'd write a query directly on your database...

sql stament with date filed

prieper — Fri, 06 Nov 2009 22:39:05 GMT

Believe that the usual SQL-syntax for dates is MM/DD/YYYY, thus would try with a WHERE-clause like
.... >='08/22/2009'.

Peter

sql stament with date filed

Sat, 07 Nov 2009 00:13:41 GMT

On SQL Server, use CONVERT:

[doc-fec] >= CONVERT(DateTime, '22/08/2009', 103)

where 103 is the code for dd/mm/yyyy formatting.

sql stament with date filed

Sat, 07 Nov 2009 03:48:10 GMT

Hi Forum

Thanks for yours answers. These help me to find the correct sintax:

sELECT emp-cod, doc-fec
fROM nom_his
wHERE (cpt-liq = 105 Or cpt-liq =125) And emp-cod = '57147' And doc-fec >= DATE('22/08/2009');

I´m working with Progress Database.