Oracle 时间问题，请指教

[huazaijiajia]

在一个表里边有一个字符型字段，存放时间
如：20050705000117

我想对这个字段都减去6秒，不知道该怎样减
请指教

[waterfirer]

SQL> select to_char(to_date('20050705000117','yyyymmddhh24miss')-6/24/3600,'yyyy
mmddhh24miss') from dual;

TO_CHAR(TO_DAT
--------------
20050705000111

SQL>

[huazaijiajia]

急啊，各位，快来人啊

[沝林]

1.

SQL> select to_date('20050705000117','yyyymmddhh24miss') - 1/24/60/60*6 from dual;

TO_DATE('20050705000117','YYYY
------------------------------
2005-7-5 0:01:11
2.

SQL> select to_date('20050705000117','yyyymmddhh24miss') - interval '6' second from dual;

TO_DATE('20050705000117','YYYY
------------------------------
2005-7-5 0:01:11
3.

SQL> select to_date('20050705000117','yyyymmddhh24miss') - numtodsinterval(6,'second') from dual;

TO_DATE('20050705000117','YYYY
------------------------------
2005-7-5 0:01:11

[huazaijiajia]

Thank you

[小李木耳]

select to_date('20050705000117','YYYYMMDDHH24MISS'),to_date('20050705000117','YYYYMMDDHH24MISS')-6/60/60/24 from dual

>2005/07/05 0:01:17 2005/07/05 0:01:11