and CAST((unix_timestamp(process_dttm) - unix_timestamp(pay_dttm)) / 60 AS int)<=10
(unix_timestamp(concat(custom.data.ArriveTime,':00')) - unix_timestamp(concat(custom.data.DepartTime,':00')))/3600 as duration
,concat(cast(nvl(a.whithin10min_order_cnt*100,0)/c.all_nonappoint_order_cnt as decimal(10,2)),'%') as 10min_order_rate
时间转换时时间戳、百分比
最新推荐文章于 2024-07-20 08:03:04 发布
![](https://img-home.csdnimg.cn/images/20240711042549.png)