指定时间增加带小数的天数

 

-- 指定时间增加带小数的天数
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  |
+------------------------+---------------+------------------------+--+

 

转载于:https://www.cnblogs.com/chenzechao/p/9724625.html