话不多说,直接上代码:
--datetime转换为float
select convert(float,current_timestamp); //43963.672012731484
--float转换为datetime
select convert(datetime,43963.670775887345); //2020-05-14 16:05:55.033
话不多说,直接上代码:
--datetime转换为float
select convert(float,current_timestamp); //43963.672012731484
--float转换为datetime
select convert(datetime,43963.670775887345); //2020-05-14 16:05:55.033