当前位置:网站首页>Oracle calculates the difference between two dates in seconds, minutes, hours and days
Oracle calculates the difference between two dates in seconds, minutes, hours and days
2022-04-23 13:40:00 【Wangcai 2】
-- Calculate the number of seconds between the two time differences
select (sysdate-to_date('2021/12/14 17:00:00','yyyy/mm/dd hh24:mi:ss'))*24*60*60 from dual
-- Calculate the difference between the two time differences
select (sysdate-to_date('2021/12/14 17:00:00','yyyy/mm/dd hh24:mi:ss'))*24*60 from dual
-- When calculating the difference between two time differences
select (sysdate-to_date('2021/12/14 17:00:00','yyyy/mm/dd hh24:mi:ss'))*24 from dual
-- Calculate how many days there is between the two time differences
select sysdate-to_date('2021/12/14 17:00:00','yyyy/mm/dd hh24:mi:ss') from dual
版权声明
本文为[Wangcai 2]所创,转载请带上原文链接,感谢
https://yzsam.com/2022/04/202204230604300916.html
边栏推荐
- 叮~ 你的奖学金已到账!C认证企业奖学金名单出炉
- Common types and basic usage of input plug-in of logstash data processing service
- Data warehouse - what is OLAP
- MySQL5. 5 installation tutorial
- Unified task distribution scheduling execution framework
- Using open to open a file in JNI returns a - 1 problem
- [point cloud series] Introduction to scene recognition
- Is Hongmeng system plagiarism? Or the future? Professional explanation that can be understood after listening in 3 minutes
- Machine learning -- PCA and LDA
- [point cloud series] foldingnet: point cloud auto encoder via deep grid deformation
猜你喜欢
Zero copy technology
How do ordinary college students get offers from big factories? Ao Bing teaches you one move to win!
Explanation of input components in Chapter 16
Tangent space
Solve the problem that Oracle needs to set IP every time in the virtual machine
Cross carbon market and Web3 to achieve renewable transformation
为什么从事云原生开发需要学习容器技术
Common types and basic usage of input plug-in of logstash data processing service
Servlet of three web components
十万大学生都已成为猿粉,你还在等什么?
随机推荐
TIA博途中基於高速計數器觸發中斷OB40實現定點加工動作的具體方法示例
./gradlew: Permission denied
[point cloud series] learning representations and generative models for 3D point clouds
Loading and using image classification dataset fashion MNIST in pytorch
Launcher hides app icons that do not need to be displayed
Detailed explanation of ADB shell top command
Bottomsheetdialogfragment + viewpager + fragment + recyclerview sliding problem
Aicoco AI frontier promotion (4.23)
Analysis of the latest Android high frequency interview questions in 2020 (BAT TMD JD Xiaomi)
Scons build embedded ARM compiler
Oracle renames objects
100000 college students have become ape powder. What are you waiting for?
Esp32 vhci architecture sets scan mode for traditional Bluetooth, so that the device can be searched
Servlet of three web components
Tersus notes employee information 516 MySQL query (time period uniqueness judgment of 2 fields)
[point cloud series] neural opportunity point cloud (NOPC)
Longitude and latitude position of provincial capitals in China
Exemple de méthode de réalisation de l'action d'usinage à point fixe basée sur l'interruption de déclenchement du compteur à grande vitesse ob40 pendant le voyage de tia Expo
The interviewer dug a hole for me: how many concurrent TCP connections can a single server have?
Usereducer basic usage