如何在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

但是通过这个我得到了这个

But by this I am getting this

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.

推荐答案

你总是可以使用分数(for Oracle 1 = 1 day):

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 演示

或:

SELECT CURRENT_TIMESTAMP + INTERVAL '200' SECOND FROM dual

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