How To Sort Date When Date Is Formatted

• anouars

  Newbie

  Points: 5

  More actions

  September 20, 2012 at 5:56 am

  #264596

  Hi all,

  I have a problem. The problem is that I want to sort dates in descending order, but the date needs to be formatted.

  The issue is that when I sort it after being formatted it is sorted on a string or varchar basis, which does not sort correctly according to the dates.

  Can anyone help me?

  Thanks in advance

• Ant-Green

  SSC Guru

  Points: 113567

  More actions

  September 20, 2012 at 6:00 am

  #1540011

  Sort on the unformatted date instead of the formatted date, something like the below

  SELECT

  CONVERT(VARCHAR,DateColumn,103) AS FormattedDate,

  DateColumn AS Non-FormattedDate

  FROM

  SomeTable

  ORDER BY

  DateColumn DESC