SQL ORDER BY date problem

by

It seems that your date column is not of type datetime but varchar. You have to convert it to datetime when sorting:

select date
from tbemp
order by convert(datetime, date, 103) ASC

style 103 = dd/MM/yyyy (msdn)

More Related Contents:

  1. Best approach to remove time part of datetime in SQL Server
  2. Sort by column ASC, but NULL values first?
  3. Count work days between two dates
  4. MySQL: Alternatives to ORDER BY RAND()
  5. PostgreSQL DISTINCT ON with different ORDER BY
  6. SQL best practice to deal with default sort order
  7. Optimize query with OFFSET on large table
  8. When no ‘Order by’ is specified, what order does a query choose for your record set?
  9. How to use DISTINCT and ORDER BY in same SELECT statement?
  10. SQL how to make null values come last when sorting ascending
  11. How to use Oracle ORDER BY and ROWNUM correctly?
  12. When to use VARCHAR and DATE/DATETIME
  13. How do I return rows with a specific value first?
  14. SQL (ORACLE): ORDER BY and LIMIT [duplicate]
  15. How do you do date math that ignores the year?
  16. Getting date list in a range in PostgreSQL
  17. How to ORDER BY a SUM() in MySQL?
  18. How to compare two dates to find time difference in SQL Server 2005, date manipulation
  19. SQLite and custom order by
  20. SQL SERVER: Get total days between two dates
  21. Add business days to date in SQL without loops
  22. Sorting string column containing numbers in SQL?
  23. “Order By” using a parameter for the column name
  24. Check whether string is a date Postgresql
  25. SQL for ordering by number – 1,2,3,4 etc instead of 1,10,11,12
  26. Return number from Oracle Select statement after parsing date
  27. SQL ORDER chars numerically
  28. Dynamic order direction
  29. Select query with date condition
  30. Oracle Convert TIMESTAMP with Timezone to DATE

Leave a Comment