How could I go about sorting dates I have saved as nvarchar in SQL

Question

Say I am trying to sort through and I want to see the dates 10/22/2020, 10/23/2020, 10/24/2020, and/or 5/5/2020. How could I do this? When I run with the following code it will not work.

AND appointmentsTable.scheduledDate = @startDate 
AND appointmentsTable.scheduledDate = @date2
AND appointmentsTable.scheduledDate = @date3
AND appointmentsTable.scheduledDate = @endDate

Screenshot of query I currently have

check this https://stackoverflow.com/questions/119730/how-do-i-sort-a-varchar-column-in-sql-server-that-contains-numbers — Amirhossein, Oct 21 '20 at 22:04

score 2 · Answer 1 · answered Oct 21 '20 at 21:58

2

You would convert to a date:

order by convert(date, appointmentdate, 101)

But you should fix your data model so dates are stored as dates.

answered Oct 21 '20 at 21:58

Gordon Linoff

1,242,037
58
646
786

Sorry, where would I insert this line? The problem is that when I attempted to bulk load the CSV file, the dates only loaded if they were of type string. How could I do this? – Yeslyn Casasola Oct 21 '20 at 22:57
@YeslynCasasola . . . `order by` goes at the end of a `select` query. – Gordon Linoff Oct 22 '20 at 01:13

How could I go about sorting dates I have saved as nvarchar in SQL

1 Answers1