SQL Server A column that looks and behaves like a date in the contingency table cannot be sorted properly

u5rb5r59 于 2023-04-04 发布在 Perl

关注(0)|答案(1)|浏览(129)

I pulled up an Excel pivot table linked to the database. I have a column in it that has a date in the format dd.mm.yyyy. The column is recognized as a date, switching between short date, long date and time works for it. It also displays the ordering from oldest to newest, rather than A to Z. But when I want to sort this column, it doesn't sort properly. For example, when I sort it from newest date to oldest, the dates come up in the following order:

which don't make sense. Do you know where is the problem? I can upload a SQL query linked to this table if it helps. Thank you for any suggestions :-)

For example, I tried to make one more column from the problem column via

CONVERT(varchar, CAST(sd.posting_date as datetime), 104) AS "Invoice date"

However, that didn't help either. This column then could not be switched to the date in Excel

sql-server

来源：https://stackoverflow.com/questions/75896852/a-column-that-looks-and-behaves-like-a-date-in-the-contingency-table-cannot-be-s

1条答案

按热度按时间

vyswwuz21#

You will need to add ORDER BY to get them sorted as follows :

In order by the datatype should datetime

select CONVERT(varchar, CAST(sd.posting_date as datetime), 104) AS "Invoice date"
from mytable sd
order by convert(datetime, sd.posting_date, 104) desc

赞(0）回复(0）举报 2023-04-04

我来回答

SQL Server A column that looks and behaves like a date in the contingency table cannot be sorted properly

1条答案

相关问题

热门标签

最新问答