关闭

Oracle/PLSQL: Extract Function

603人阅读 评论(0) 收藏 举报

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;

0
0

查看评论
* 以上用户言论只代表其个人观点,不代表CSDN网站的观点或立场
    个人资料
    • 访问:481372次
    • 积分:5526
    • 等级:
    • 排名:第4953名
    • 原创:73篇
    • 转载:160篇
    • 译文:0篇
    • 评论:31条
    文章分类
    最新评论