Need to reformat Quarterly Date in SQL Server: 2021-Q2 should be shown as “Q2 / 21”

juud5qan 于 2022-12-22 发布在 SQL Server

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

Example: I have a column which have values in the format of 2021-Q2 .
How do I reformat those values to the format Q2/21 ?
I had tried substring .

sql-server

来源：https://stackoverflow.com/questions/74800559/need-to-reformat-quarterly-date-in-sql-server-2021-q2-should-be-shown-as-q2

1条答案

按热度按时间

oyjwcjzk1#

declare @InString varchar(10)='2021-Q2'

select RIGHT(@InString,2)+'/'+RIGHT(LEFT(@InString,4),2);

赞(0）回复(0）举报 2022-12-22

我来回答

Need to reformat Quarterly Date in SQL Server: 2021-Q2 should be shown as “Q2 / 21”

1条答案

相关问题

热门标签

最新问答