Oracle/PLSQL: Extract Function

Oracle/PLSQL: Extract Function


In Oracle/PLSQL, the extract function extracts a value from a date or interval value.

The syntax for the extract function is:

EXTRACT (
            { YEAR | MONTH | DAY | HOUR | MINUTE | SECOND }
            | { TIMEZONE_HOUR | TIMEZONE_MINUTE }
            | { TIMEZONE_REGION | TIMEZONE_ABBR }
            FROM { date_value | interval_value } )

You can only extract YEAR, MONTH, and DAY from a DATE.

You can only extract TIMEZONE_HOUR and TIMEZONE_MINUTE from a timestamp with a time zone datatype.

Applies To:

  • Oracle 9i, Oracle 10g, Oracle 11g

For Example:

extract(YEAR FROM DATE '2003-08-22')

would return 2003

extract(MONTH FROM DATE '2003-08-22')

would return 8

extract(DAY FROM DATE '2003-08-22')

would return 22

 

select extract(year  from sysdate) from dual;

阅读更多
个人分类: Oracle Database
想对作者说点什么? 我来说一句

没有更多推荐了,返回首页

不良信息举报

Oracle/PLSQL: Extract Function

最多只允许输入30个字

加入CSDN,享受更精准的内容推荐,与500万程序员共同成长!
关闭
关闭