1 Reply Latest reply: Jan 13, 2011 12:08 PM by Anil Konduri RSS

    SQL Query problem

      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