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

    JCR SQL2 query comparing dates

    JS Bournival Level 1

      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.