当前位置:网站首页>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
边栏推荐
- Download xshell 6 and xftp6 official websites
- Accessing private members using templates
- Keysight has chosen what equipment to buy for you
- arcMap 发布切片服务
- js获取本机ip地址
- The type initializer for ‘Gdip‘ threw an exception
- JVM的类加载过程
- All table queries and comment description queries of SQL Server
- Using bafayun to control the computer
- An 8266 crash
猜你喜欢
![[报告] Microsoft :Application of deep learning methods in speech enhancement](/img/29/2d2addd826359fdb0920e06ebedd29.png)
[报告] Microsoft :Application of deep learning methods in speech enhancement

Druid SQL和Security在美团点评的实践

【历史上的今天】4 月 23 日:YouTube 上传第一个视频;网易云音乐正式上线;数字音频播放器的发明者出生

为何PostgreSQL即将超越SQL Server?

2022.04.23(LC_763_划分字母区间)

Wechat applet part of the mobile phone Preview PDF did not respond

Eight bit binary multiplier VHDL

ESP32 LVGL8. 1 - msgbox message box (msgbox 28)

剑指 Offer II 116. 省份数量-空间复杂度O(n),时间复杂度O(n)

From technical system to business insight, the closing chapter of the practice of small and medium-sized R & D team structure
随机推荐
After opening the original normal project, the dependency package displays red and does not exist.
arcMap 发布切片服务
Regular expressions for judging positive integers
SSDB基础
Codeforces Round #784 (Div. 4)
How can programmers quickly develop high-quality code?
Switching power supply design sharing and power supply design skills diagram
Simple use of navigation in jetpack
Click the input box to pop up the keyboard layout and move up
Getting started with vcpkg
Practice of Druid SQL and security in meituan review
#yyds干货盘点#stringprep --- 因特网字符串预备
An 8266 crash
Introduction to micro build low code zero Foundation (lesson 3)
openlayers 5.0 两种居中方式
MVVM model
网络协议之:sctp流控制传输协议
ArcMap连接 arcgis server
2022.04.23(LC_763_划分字母区间)
RPM包管理