如何在oracle时间戳中添加秒 [英] how to add second in oracle timestamp

问题描述

如何在Oracle中添加带有时间戳值的秒数. 我试过了....

How can I add seconds with timestamp value in Oracle. I tried this ....

SELECT CURRENT_TIMESTAMP , CURRENT_TIMESTAMP+200 AS addedTime FROM dual

但是通过这个我得到了

2018-06-04 19:03:01 => 2018-12-21 19:03:01(添加200后)

2018-06-04 19:03:01 => 2018-12-21 19:03:01 (after adding 200)

您可以看到日期正在添加，但是我只想添加第二个...

As you can see date is getting added , but I want to add second only...

此SQL在DB2中正常运行，可以有人建议我在Oracle中使用任何合适的替代方法.

This SQL running properly in DB2 , can any one suggest me any suitable alternative in Oracle.

推荐答案

您始终可以使用分数(对于Oracle 1 = 1天):

You could always use fraction(for Oracle 1 = 1 day):

SELECT CURRENT_TIMESTAMP ,
       CURRENT_TIMESTAMP + 200 *(1/24/60/60) AS addedTime 
FROM dual;
<=>
SELECT CURRENT_TIMESTAMP + 200/86400 FROM dual

DBFiddle演示

DBFiddle Demo

或:

SELECT CURRENT_TIMESTAMP + INTERVAL '200' SECOND FROM dual

这篇关于如何在oracle时间戳中添加秒的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！