Question & Answer > View Question

how do i query this field (datatype = varchar) to sort the descending order.

Confluence User - 23 Feb, 2019

Hai all,

I have one variable name which is Date and my datatype VARCHAR. So my question is how can i do the query to sorting the date variable in descending order. Cause i have done the query part and the result still not in proper way. cause the query only compare the 2 no. in front

This is sample my data and sorting result

datalists;userviews;server

1

Confluence User •

23 Feb, 2019 •

confluenceUser •

1 •

confluenceUser •

select *,
ROW_NUMBER() OVER (ORDER BY tenantID) AS No,
Convert(INT,SUBSTRING(dueDate, 1, 2))AS Days,
Convert(INT,SUBSTRING(dueDate,4,2)) AS Months,
Convert(INT,SUBSTRING(dueDate, 7,9))AS Years
from app_fd_finalReportTenant
where statusPlace <> 'Vacant'
and statusPlace <> 'Expired'
order by Months,Years,Days ASC

I get an answer in query part. but when i paste the query in Joget it say cannot retrieve column. Can help me?

1

CSV | Excel | XML | PDF

Your answer

Print

how do i query this field (datatype = varchar) to sort the descending order.

1

RELATED QUESTIONS

Your answer

To answer a question you'll need an account.

1.builder-style-c6effd80-8c2d-4c5b-abbe-9e75c9f480b3{color:#008C60 !important;}

RELATED QUESTIONS

Your answer.builder-style-f9519dfe-cdf1-4a62-9468-f5923f6667d4{color:#008C60 !important; margin-left:10px !important;}

To answer a question you'll need an account.

1

Your answer