SELECT 空气温度,cast(空气温度/10 as int) AS [转换后温度]
FROM tabAddress 现在的结果:
--------------------------------
空气温度 转换后温度
255 25=========================我想要的结果--------------------------------
空气温度 转换后温度
255 25.5
FROM tabAddress 现在的结果:
--------------------------------
空气温度 转换后温度
255 25=========================我想要的结果--------------------------------
空气温度 转换后温度
255 25.5
FROM tabAddress
FROM tabAddress
SELECT 空气温度,cast(空气温度/10 as decimal(18,1)) AS [转换后温度]
FROM tabAddress
FROM tabAddress
FROM tabAddress
FROM tabAddress
正解,谢谢
SELECT 空气温度,cast(空气温度*1.0/10 as numeric(8,2)) AS [转换后温度]
FROM tabAddress
FROM tabAddress
cast(空气温度*0.1/1 as float)
--or
cast(空气温度*1。0/10 as float)
SELECT 空气温度,cast(空气温度/10.0 as decimal(13,1)) AS [转换后温度]
FROM tabAddress
FROM tabAddress
numeric(10,2) 保留两位小数 ,2 可以自己改,10表示总长度 也可以自己设置
FROM tabAddress