1. convert(数据类型, 字段名)
convert(datetime, startDate)
convert(datetime, startDate,126) //输入示例:2019-01-01
convert(varchar(10), name)
2. cast(字段名 as 数据类型)
cast(price as decimal(9,2))
1. convert(数据类型, 字段名)
convert(datetime, startDate)
convert(datetime, startDate,126) //输入示例:2019-01-01
convert(varchar(10), name)
2. cast(字段名 as 数据类型)
cast(price as decimal(9,2))