SQL Server Concat and make a string into a date

cczfrluj 于 2023-08-02 发布在其他

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

I have a table where the month and year are separate, and I want to put them together and make the backend format to date. I tried cast/converting but I get an error of "Conversion failed when converting date and/or time from character string"

This is the data

Accountingperiod | Accounting year
1                    2023
2                    2024
3                    2023
10                   2024

desired out put or any date output as long as its date

and when I output I try to cast the result but I get an error because of the string . Here is my code

select cast(concat(tb.AccountingPeriod,tb.AccountingYear) as date) as month_year_date  
from  ttbl_a  tb

sql-server

来源：https://stackoverflow.com/questions/76683219/concat-and-make-a-string-into-a-date

1条答案

按热度按时间

cnwbcb6i1#

Thanks @siggemannen, I used the below and it gave me what I want.

select DATEFROMPARTS (AccountingYear,AccountingPeriod,1) as yy_mm_date from ttbl_a

output

yy_mm_date
2023 -01-01  
2024 -02-01 
2023 -03-01 
2024 -10-01

赞(0）回复(0）举报 2023-08-02

我来回答

SQL Server Concat and make a string into a date

1条答案

相关问题

热门标签

最新问答