SQL2 String to Date | Community
Skip to main content
T
tim-schwalbe-NZ
Level 3
November 27, 2017

SQL2 String to Date

  • November 27, 2017
  • 1 reply
  • 1954 views

Hello I want to ask if it is possible to convert a String to Date, because its is not possible to change the datatype to date because production data can't be changed easily.

Here is my first try but it does not work as expected:

SELECT * FROM [nt:unstructured] as ref WHERE ISDESCENDANTNODE(ref,[/content/jobs/jcr:content/jobData]) AND ref.Function='Legal'

AND ref.date >= CAST('07-07-2017' AS date)  ORDER BY ref.date ASC

After converting it I want to order the nodes by the date.

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

1 reply

smacdonald2008
smacdonald2008
Level 10
November 27, 2017

This subject is discussed here - JCR SQL2 query comparing dates - Stack Overflow

smacdonald2008
smacdonald2008
Level 10
November 27, 2017

ALso - if you cannot cast and sort by a cast operation - then write sort logic using Java.

Terms & ConditionsAccessibility statement

Loading footer...