extract(month from xxx)
extract(year from xxx)
其中xxx為Date數(shù)據(jù)類型
詳細(xì)說明
extract(c1 from d1)?
【功能】：日期/時(shí)間d1中，參數(shù)(c1)的值?
【參數(shù)】：d1日期型(date)/日期時(shí)間型(timestamp),c1為字符型(參數(shù))?
【參數(shù)表】：c1對(duì)應(yīng)的參數(shù)表詳見示例?
?【返回】：字符?
?【示例】 select extract(hour from timestamp '2001-2-16 2:38:40 ' ) 小時(shí), extract(minute from timestamp '2001-2-16 2:38:40 ' ) 分鐘, extract(second from timestamp '2001-2-16 2:38:40 ' ) 秒, extract(DAY from timestamp '2001-2-16 2:38:40 ' ) 日, extract(MONTH from timestamp '2001-2-16 2:38:40 ' ) 月, extract(YEAR from timestamp '2001-2-16 2:38:40 ' ) 年 from dual;?
?select extract (YEAR from date '2001-2-16' ) from dual;?
?select sysdate 當(dāng)前日期, extract(hour from systimestamp) 小時(shí), extract(DAY from sysdate ) 日, extract(MONTH from sysdate ) 月, extract(YEAR from sysdate ) 年 from dual;
更多oracle中與日期相關(guān)的函數(shù)可以參考這個(gè)鏈接
oracle日期相關(guān)函數(shù)
