sql server 时间初始化(int,string 转DateTime)

 

select CAST(CAST(2022 AS VARCHAR) + '-' + CAST(1 AS VARCHAR) + '-' + CAST(1 AS VARCHAR) AS DATETIME)

 

posted @ 2022-12-08 09:33  qingjiawen  阅读(172)  评论(0编辑  收藏  举报