Extracts the a portion of a date, time, or timestamp value.

Syntax

---

EXTRACT(<ValueToExract> FROM <DateTimeExpression>)
EXTRACT(<ValueToExract>, <DateTimeExpression>)

<ValueToExtract> =

YEAR
MONTH
WEEK
DAYOFWEEK
DAYOFYEAR
DAY
HOUR
MINUTE
SECOND
MSECOND

<DateTimeExpression> =

DATE
TIME
TIMESTAMP

Returns

---

INTEGER

Usage

---

The EXTRACT function extracts a designated portion of a date, time, or timestamp value and returns it. The following table details which portions can be extracted from which types:



Examples

---

SELECT *
FROM Transactions
WHERE EXTRACT(YEAR FROM TransDateTime) = 2006

SQL 2003 Standard Deviations

---

This function deviates from the SQL 2003 standard in the following ways: