-- 指定时间增加带小数的天数
select
day
,add_date_num
,cast(cast(day as bigint) + add_date_num * 24 * 60 * 60 as timestamp) as timestamp_new
from (
select cast('2018-01-01' as timestamp) as day,1.10 as add_date_num union all
select cast('2018-01-01' as timestamp) as day,1.21 as add_date_num union all
select cast('2018-01-01' as timestamp) as day,1.32 as add_date_num union all
select cast('2018-01-01' as timestamp) as day,1.43 as add_date_num union all
select cast('2018-01-01' as timestamp) as day,1.54 as add_date_num union all
select cast('2018-01-01' as timestamp) as day,1.65 as add_date_num
) t1
;
+------------------------+---------------+------------------------+--+
| day | add_date_num | timestamp_new |
+------------------------+---------------+------------------------+--+
| 2018-01-01 00:00:00.0 | 1.1 | 2018-01-02 02:24:00.0 |
| 2018-01-01 00:00:00.0 | 1.21 | 2018-01-02 05:02:24.0 |
| 2018-01-01 00:00:00.0 | 1.32 | 2018-01-02 07:40:48.0 |
| 2018-01-01 00:00:00.0 | 1.43 | 2018-01-02 10:19:12.0 |
| 2018-01-01 00:00:00.0 | 1.54 | 2018-01-02 12:57:36.0 |
| 2018-01-01 00:00:00.0 | 1.65 | 2018-01-02 15:36:00.0 |
+------------------------+---------------+------------------------+--+
