Oracle/PLSQL: Extract Function

最新推荐文章于 2023-04-05 23:46:18 发布

Wuaner

最新推荐文章于 2023-04-05 23:46:18 发布

阅读量64

点赞数

CC 4.0 BY-SA版权

分类专栏： Oracle 文章标签： Oracle SQL PHP HTML

本文链接：https://blog.youkuaiyun.com/Wuaner/article/details/83523049

Oracle 专栏收录该内容

68 篇文章

订阅专栏

本文详细介绍了Oracle/PLSQL中的EXTRACT函数，该函数用于从日期或间隔值中提取特定部分，如年份、月份或天数等。文章通过具体示例展示了如何使用EXTRACT函数来获取日期的不同组成部分。

Oracle/PLSQL: Extract Function:
[url]http://www.techonthenet.com/oracle/functions/extract.php[/url]

[url]extract [Oracle SQL]:[/url]
[url]http://www.adp-gmbh.ch/ora/sql/extract.html[/url]

[url]http://www.cnblogs.com/ruanbl/archive/2008/02/29/1086398.html[/url]

[quote]
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
[/quote]