当前位置:网站首页>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
边栏推荐
- Detailed explanation of constraints of Oracle table
- 交叉碳市场和 Web3 以实现再生变革
- [walking notes]
- Isparta is a tool that generates webp, GIF and apng from PNG and supports the transformation of webp, GIF and apng
- 榜样专访 | 孙光浩:高校俱乐部伴我成长并创业
- Comparison and summary of applicable scenarios of Clickhouse and MySQL database
- 联想拯救者Y9000X 2020
- XML
- 软考系统集成项目管理工程师全真模拟题(含答案、解析)
- Publish custom plug-ins to local server
猜你喜欢
Zero copy technology
Isparta is a tool that generates webp, GIF and apng from PNG and supports the transformation of webp, GIF and apng
[point cloud series] pointfilter: point cloud filtering via encoder decoder modeling
普通大学生如何拿到大厂offer?敖丙教你一招致胜!
Common interview questions and detailed analysis of the latest Android developers in 2020
Campus takeout system - "nongzhibang" wechat native cloud development applet
[point cloud series] learning representations and generative models for 3D point clouds
Solve the problem that Oracle needs to set IP every time in the virtual machine
TIA博途中基於高速計數器觸發中斷OB40實現定點加工動作的具體方法示例
面试官给我挖坑:URI中的 “//” 有什么用?
随机推荐
TIA博途中基于高速计数器触发中断OB40实现定点加工动作的具体方法示例
解决tp6下载报错Could not find package topthink/think with stability stable.
SAP UI5 应用开发教程之七十二 - SAP UI5 页面路由的动画效果设置试读版
Modification of table fields by Oracle
[notes de marche]
[point cloud series] relationship based point cloud completion
GDB的使用
QT调用外部程序
Imx6ull QEMU bare metal tutorial 2: usdhc SD card
@优秀的你!CSDN高校俱乐部主席招募!
Lenovo Savior y9000x 2020
2021年6月程序员工资统计,平均15052元,你拖后腿了吗?
Aicoco AI frontier promotion (4.23)
Opening: identification of double pointer instrument panel
LeetCode_ DFS_ Medium_ 695. Maximum area of the island
【重心坐标插值、透视矫正插值】原理以及用法见解
Innobackupex incremental backup
联想拯救者Y9000X 2020
Xi'an CSDN signed a contract with Xi'an Siyuan University, opening a new chapter in IT talent training
What do the raddr and rport in webrtc ice candidate mean?