Syntax
EXTRACT(date_field FROM date)
EXTRACT()
Required.
date_field
Required. The date part that is to be extracted. See below
for a complete list of date parts that can be used in this
parameter. Click to see a list of valid
datefield options.
FROM
Required.
date
Required. A date formatted as any valid SQL92 date_class
datatype.
Valid datefield Options
- YEAR
- MONTH
- DAY
- HOUR
- MINUTE
- SECOND
- W - Day of the week number (1-Sunday, 2-Monday)
- WW - Three-character day-of-week abbreviation (Sun, Mon)
- WWW - Fully spelled day-of-week (Sunday, Monday)
- M - Non-zero-filled month number (1-January, 2-February)
- 0M - Zero-filled day-of-month number (01-January, 02-February)
- MM - Three-character month abbreviation (Jan, Feb)
- MMM - Fully spelled month (January, February)
- D - Non-zero-filled day-of-month (1, 2, 3)
- 0D - Zero-filled day-of-month (01, 02, 03)
- J - Non-zero-filled Julian date (1, 2)
- 0J - Zero-filled Julian date (01, 02)
- YY - Two-digit year (99, 00)
- YYYY - Four-digit year (1999, 2000)
- H - 12-hour, non-zero-filled hour of day (12, 1)
- 0H - 12-hour, zero-filled hour of day (12, 01)
- HH - 24-hour, non-zero-filled hour of day (24, 1)
- 0HH - 24-hour, zero-filled hour of day (24, 01)
- N - Non-zero-filled minute of hour (1, 2)
- 0N - Zero-filled minute of hour (01, 02)
- S - Non-zero-filled second of minute (1, 2)
- 0S - Zero-filled second of minute (01, 02)
- F - Non-zero-filled fraction of a second (1, 2)
- 0F - Zero-filled fraction of a second (01, 02)
- A - Lowercase am/pm indicator
- AA - Uppercase AM/PM indicator
top
Example
select status,
extract(
mmm
FROM
orders.order_date)
from orders
where product_no='PRN4356'
ORDR JANUARY
ORDR DECEMBER
CNCL MARCH
top
|