SQL怎么取日期间相差天数，日期格式为 2022-01-01 12:12:12
select round(XS*TO_NUMBER((TO_DATE('2019-01-01 19:51:20','yyyy-mm-dd hh24:mi:ss')- TO_DATE('2019-01-05 21:50:20','yyyy-mm-dd hh24:mi:ss'))),2)from TEST
1min目标场景问卷
立即参与
