SQL-2 Query

Harish Singh asked 2 years ago

I am Facing one issue. My article date property i.e jcr:datetime were stored in below format. Where property type is date
Jcr:datetime 11/11/2017
So when i do order by jcr:datetime iam getting improper results because jcr:datetime type is string not date. Without chaining the type in my whole content. Is there any solution where i can do with sql-2 query.

SELECT * FROM [cq:PageContent] AS s WHERE ISDESCENDANTNODE(s,’/content/rewrite/en_us/topic’) and s.[jcr:datetime] IS NOT NULL order by s.[jcr:datetime]

8 Answers
Thanos answered 9 months ago

There are the very nice post for me i must be like to share the add network printer windows 10 this is the device to support the all system version easily for batter working.

Victoria Carson answered 7 months ago

SQL characterizes methods for characterizing and pulverizing tables, information section, refresh and erasure in addition to other things. do my college homework Most normal social databases are PostgreSQL, Oracle DB, IBM DB2, MySQL, SQL Server, SQLite among others.

Shehroz Qasim answered 7 months ago

MySQL database is very necessary for these days in any kind of web development and design services, as an IT student I have taken online assignment help for my academic activities but after taking 2 to 3 times help I am able to develop the website and using the SQL server.

Angela Kinsey answered 7 months ago

I am new to MySQL and yet learning PHP. I am attempting to build a login area Do My Essay that will recover a user name and password in the DB when using an if statement to verify the credentials later if I get to that step start a session. I have everything decided out in theory but some lack of PHP experience is holding me back. Basically, I want to take this string and change it into one big variable.

reyan answered 6 months ago

However, the points are not gone completely. We’ve collected tips to collect points in two different Microsoft price programs. earn xbox live gold

Your Answer