Dive into Adobe Summit 2024! Explore curated list of AEM sessions & labs, register, connect with experts, ask questions, engage, and share insights. Don't miss the excitement.
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
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)
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)