将varchar转换为datetime以排序日期？

Question

I want to try sorting dates but there are constraints, because those columns are varchar.

This existing data

This is the query that I test.

SELECT        PERIODE, RF, APPROVE_DATE
FROM            DLY_UPGRADE
WHERE        (SLP = '368') AND (CONVERT(datetime, APPROVE_DATE, 101) > '01/01/2017')

The error message :

Answer 1

If you are using SQL Server, try the following:

SELECT        PERIODE, RF, APPROVE_DATE
FROM            DLY_UPGRADE
WHERE        (SLP = '368') AND (CONVERT(date, APPROVE_DATE, 103) > '2017-01-01')