plsql 中怎么在日期中分别提取年,月,日,时,分,秒 的函数? 解决问题马上结帐

Question

to_char(datetype,'YYYY');
to_char(datetype,'mm')
.....

Answer 1

select to_char(to_date('2003-8-29','yyyy/mm/dd'),'yyyy') yyyy,
to_char(to_date('2003-8-29','yyyy/mm/dd'),'mm') mm,
to_char(to_date('2003-8-29','yyyy/mm/dd'),'dd') dd from dual;

Answer 2

SQL> select to_char(sysdate,'hh24') from dual;TO_CHAR(SYSDATE,'HH24')
-----------------------
09SQL> select to_char(sysdate,'ss') from dual;TO_CHAR(SYSDATE,'SS')
---------------------
10SQL> select to_char(sysdate,'mi') from dual;TO_CHAR(SYSDATE,'MI')
---------------------
09

Answer 3

SQL> select to_char(sysdate,'yyyy-mm-dd hh24:mi:ss') from dual;TO_CHAR(SYSDATE,'YY
-------------------
2003-08-29 12:30:43SQL>