-
How To Add Day, Hour, Minute, Second to a Date Value in Oracle
- Add a day.
select to_date('02-22-2008 10:30:30','mm-dd-yyyy hh24:mi:ss') today,
to_date('02-22-2008 10:30:30','mm-dd-yyyy hh24:mi:ss')+1 next_day
from dual;
TODAY NEXT_DAY
------------------------- -------------------------
02-22-08 10:30:30 02-23-08 10:30:30
- Add an hour.
select to_date('02-22-08 10:30:30','mm-dd-yy hh24:mi:ss') today,
to_date('02-22-08 10:30:30','mm-dd-yy hh24:mi:ss')+ 1/24 next_hour
from dual;
TODAY NEXT_HOUR
------------------------ ------------------------
02-22-08 10:30:30 02-22-08 11:30:30
- Add a minute.
select to_date('02-22-08 10:30:30','mm-dd-yy hh24:mi:ss') today,
to_date('02-22-08 10:30:30','mm-dd-yy hh24:mi:ss')+ 1/(24*60) next_min
from dual;
TODAY NEXT_MIN
------------------------ ------------------------
02-22-08 10:30:30 02-22-08 10:31:30
- Add a second.
select to_date('02-22-08 10:30:30','mm-dd-yy hh24:mi:ss') today,
to_date('02-22-08 10:30:30','mm-dd-yy hh24:mi:ss')+ 1/(24*60*60) next_sec
from dual;
TODAY NEXT_SEC
------------------------ ------------------------
02-22-08 10:30:30 02-22-08 10:30:31
-
相关阅读:
架构思维—软件架构—系统架构—系统—大局观、系统观(结构与秩序)、还原论(分与合)
微核架构的本质是微核掌握了更多的上下文-----微核架构 = 整体上下文 + 配置组成
spring mvc的工作流程
@getMapping和@postMapping,@RestController
springTransaction Management
Architecture of Spring Framework
Tomcat 6 —— Realm域管理
Tomcat模型结构
spring的启动过程
ServletContext、webApplicationContext、DispatcherServlet与容器
-
原文地址:https://www.cnblogs.com/QDuck/p/2482372.html
Copyright © 2020-2023
润新知