SQL Query problem

Thu, 13 Jan 2011 16:29:30 GMT

Hi,

I'm trying to get all the data of a table after a year, but it seems it doesn't work:

SQL SELECT *
FROM "TI_METRICS".SYSTEMLOGS
WHERE (YEAR(systemlogs.data)>'2009');

systemlogs:

id_host (integer)

hostname (text)

hits (integer)

data (timestamp DD/MM/YYY hh:mm:[ss])

How could I get that info?

Thanks

Thu, 13 Jan 2011 17:08:16 GMT

Try this

SQL SELECT *
FROM "TI_METRICS".SYSTEMLOGS
WHERE systemlogs.data >= to_date('01/01/2009 00:00:00', 'DD/MM/YYYY HH24:MI:SS');

topic SQL Query problem in QlikView