当前位置：网站首页>SQL of contention for system time plus time in ocrale database

SQL of contention for system time plus time in ocrale database

2022-04-23 19:10:00 【Little brother】

 

Make a note of , Change the time sql:

select sysdate,to_char(sysdate+1/24,'yyyy-mm-dd HH24:MI:SS') from dual; -- Add 1 Hours

-------------- Other ：
select sysdate,add_months(sysdate,12) from dual; -- Add 1 year
select sysdate,add_months(sysdate,1) from dual; -- Add 1 month
select sysdate,to_char(sysdate+7,'yyyy-mm-dd HH24:MI:SS') from dual; -- Add 1 week
select sysdate,to_char(sysdate+1,'yyyy-mm-dd HH24:MI:SS') from dual; -- Add 1 God
select sysdate,to_char(sysdate+1/24,'yyyy-mm-dd HH24:MI:SS') from dual; -- Add 1 Hours
select sysdate,to_char(sysdate+1/24/60,'yyyy-mm-dd HH24:MI:SS') from dual; -- Add 1 minute bai
select sysdate,to_char(sysdate+1/24/60/60,'yyyy-mm-dd HH24:MI:SS') from dual; -- Add 1 second

 

 

版权声明
本文为[Little brother]所创，转载请带上原文链接，感谢
https://yzsam.com/2022/04/202204210601422494.html

边栏推荐

猜你喜欢

随机推荐