SQL SERVER:
SELECT DATEADD( minute,-10,GETDATE())
ORACLE:
SELECT to_char(sysdate -interval '10' minute,'yyyy-mm-dd hh24:mi:ss') from dual
CAST(COL AS DATETIME) --时间转化
SQL SERVER:
SELECT DATEADD( minute,-10,GETDATE())
ORACLE:
SELECT to_char(sysdate -interval '10' minute,'yyyy-mm-dd hh24:mi:ss') from dual
CAST(COL AS DATETIME) --时间转化