How to order by date in SQL?

Question

When I am using order by date, the result set is sorted by date but not including the year. Can anyone tell me how to use the order by date column?

Answer 1

The reason may be because the DateTime is varchar datatype but not in date format. So, try the following SQL query to order the rows by date column:

SELECT *

FROM Table_name

            CONVERT (DateTime, date_column, 101) ASC|DESC

If you want to learn SQL from Industry experts then take up this SQL Training course by Intellipaat that provides Instructor-led training, hands-on experience, and certification.