JCR SQL2 Query | Community
Skip to main content
mrutyunjayd7834
New Participant
Apr 17, 2019 7:24 AM UTC
Solved

JCR SQL2 Query

I am dynamically reading Form Date Field and passing it to JCR SQL2  for CASTING string to DATE , getting illegal parsing error.Please suggest right JCR SQL2 Query for string Date Csting

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Gaurav-Behl
Gaurav-BehlAccepted solution
Level 10
Apr 17, 2019 2:02 PM UTC

check  9 JCR-SQL2 Queries Every AEM Developer Should Know - Blog - 6D Global

SELECT p.* FROM [nt:base] AS p WHERE p.[cq:lastModified] >= CAST('2008-01-01T00:00:00.000Z' AS DATE) AND p.[cq:lastModified] <= CAST('2008-12-31T23:59:59.999Z' AS DATE)

or

SELECT p.* FROM [nt:base] AS p
WHERE p.[some_date] >= CAST('2008-01-01T00:00:00.000Z' AS DATE)

  AND p.[some_date] <= CAST('2008-12-31T23:59:59.999Z' AS DATE)

View reply

1 reply

Gaurav-Behl
Gaurav-BehlAccepted solution
Level 10
Apr 17, 2019 2:02 PM UTC

check  9 JCR-SQL2 Queries Every AEM Developer Should Know - Blog - 6D Global

SELECT p.* FROM [nt:base] AS p WHERE p.[cq:lastModified] >= CAST('2008-01-01T00:00:00.000Z' AS DATE) AND p.[cq:lastModified] <= CAST('2008-12-31T23:59:59.999Z' AS DATE)

or

SELECT p.* FROM [nt:base] AS p
WHERE p.[some_date] >= CAST('2008-01-01T00:00:00.000Z' AS DATE)

  AND p.[some_date] <= CAST('2008-12-31T23:59:59.999Z' AS DATE)

Translate
Terms & ConditionsAccessibility statement

Loading footer...