Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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');