update GOODS set SHIPPMENT_DT = CAST(FLOOR( CAST( SHIPPMENT_DT AS FLOAT ))AS DATETIME );
Trim time in SQL server
最新推荐文章于 2023-06-04 23:45:34 发布
update GOODS set SHIPPMENT_DT = CAST(FLOOR( CAST( SHIPPMENT_DT AS FLOAT ))AS DATETIME );