1 Reply Latest reply on Feb 27, 2013 9:35 AM by Davide G

    JCR SQL2 query comparing dates

    JS Bournival

      I'm having a hard time finding out to compare dates using the SQL2 query language.

       

      I want to be able to do stuff like this:

       

      SELECT p.* FROM [nt:base] AS p WHERE EXTRACT(YEAR FROM p.[some_date]) = "2008"
      

       

      Is it possible?  What are the best techniques for these king of constraints?

       

      Thank you.