关于处理小数点位数的几个oracle函数()
1. 取四舍五入的几位小数
select round(1.2345, 3) from dual; 结果:1.235 2. 保留两位小数,
只舍 select trunc(1.2345, 2) from dual; 结果:1.23
但select round() 小数位为0是会舍掉小数位,如round(1.00) 结果:1
因此要用到 cast
cast(round(字段名,2) as numeric(20,2)) as 别名
select cast(round(10.123232,2) as numeric(20,2))
结果:10.12
select cast(round(10,2) as numeric(20,2))
结果:10.00
select 时间至分钟级
select to_char(datetime,'yyyy-mm-dd hh24:mi')
最终sql:
select cast(round(latitude,2)AS NUMBER (10, 2)) as latitude,cast(round(longitude,2)AS NUMBER (10, 2)) as longitude,to_char(datetime,'yyyy-mm-dd hh24:mi') as datetime,CG_IC,height,intens from table
参考:https://blog.csdn.net/Bliss_27/article/details/80909193?utm_source=blogxgwz0
https://www.cnblogs.com/remember-forget/p/7978125.html
http://www.itpub.net/thread-1592554-1-1.html