Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

mrutyunjayd7834
mrutyunjayd7834
Offline

Badges

Badges
2

Accepted Solutions

Accepted Solutions
0

Likes

Likes
0

Posts

Posts
1

Discussions

Discussions
0

Questions

Questions
1

Ideas

Ideas
0

Blog Posts

Blog Posts
0
Top badges earned by mrutyunjayd7834
Customize the badges you want to showcase on your profile
Re: JCR SQL2 Query
Avatar
Ignite 1
Community Advisor
Gaurav-Behl
Community Advisor

Likes

272 likes

Total Posts

1,152 posts

Correct reply

285 solutions
Top badges earned
Ignite 1
Give Back 1000
Give back 900
Give Back 800
Give Back 700
View profile
Gaurav-Behl
- Adobe Experience Manager
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)orSELECT p.* FROM [nt:base] AS pWHERE 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)

Views

235

Likes

0

Replies

0