实验环境:sql server 2008 R2 declare @maomao365 varchar(30) set @maomao365 ='2019-11-21' select convert(datetime,@maomao365), cast(@maomao365 as datetime) |
实验环境:sql server 2008 R2 declare @maomao365 varchar(30) set @maomao365 ='2019-11-21' select convert(datetime,@maomao365), cast(@maomao365 as datetime) |