oracle 常用的日期函数

最新推荐文章于 2025-07-14 14:09:00 发布

一切顺势而行

最新推荐文章于 2025-07-14 14:09:00 发布

阅读量468

点赞数

CC 4.0 BY-SA版权

本文链接：https://blog.youkuaiyun.com/x17809211858/article/details/81322489

 
SQL> select sysdate from dual;
 
SYSDATE
-----------
2018/7/31 2
 
SQL> select to_char(sysdate,'yyyy-mm-dd HH24:mm:ss') from dual;
 
TO_CHAR(SYSDATE,'YYYY-MM-DDHH2
------------------------------
2018-07-31 22:07:35
 
SQL> select * next_day from dual;
 
select * next_day from dual
 
ORA-00923: 未找到要求的 FROM 关键字
 
SQL> select next_day(sysdate) from dual;
 
select next_day(sysdate) from dual
 
ORA-00909: 参数个数无效
 
SQL> select to_date("2012-04-12","yyyy-MM-dd") from dual;
 
select to_date("2012-04-12","yyyy-MM-dd") from dual
 
ORA-00904: "yyyy-MM-dd": 标识符无效
 
SQL> select to_date("2012-04-12","yyyy-MM-dd") from dual;
 
select to_date("2012-04-12","yyyy-MM-dd") from dual
 
ORA-00904: "yyyy-MM-dd": 标识符无效
 
SQL> select to_date('2012-04-12','yyyy-MM-dd') from dual;
 
TO_DATE('2012-04-12','YYYY-MM-
------------------------------
2012/4/12
 
SQL> select add_months(sysdate,3) from dual;
 
ADD_MONTHS(SYSDATE,3)
---------------------
2018/10/31 22:33:43