CONVERT()转化函数的用法

CONVERT()转化函数的用法:

(1)日期转字符串

(2)字符串也可转日期

如:SELECT CONVERT(datetime,'20070405'): 2007-04-05 00:00:00.000 SELECT CONVERT(varchar(10),CAST('20070405' AS datetime),120): 2007-04-05

原文地址:https://www.cnblogs.com/damoblog/p/8145501.html