如何在oracle时间戳中添加第二个
如何在 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
相关文章