1、字符串转时间
select cast('1982-12-31' as datetime)
结果 :1982-12-31 00:00:00.000
2 、时间转字符串
select convert(varchar,getdate(),108)
结果: 10:23:27
select convert(varchar,getdate(),112)
结果:20080512
1、字符串转时间
select cast('1982-12-31' as datetime)
结果 :1982-12-31 00:00:00.000
2 、时间转字符串
select convert(varchar,getdate(),108)
结果: 10:23:27
select convert(varchar,getdate(),112)
结果:20080512