The EXTRACT function extracts one or more portions of a date, such as a day, month or year. This is useful for performing logic on portions of a date, such as performing certain actions in certain months. This is also useful for assembling a date string in a specific format.

This function returns a different datatype based on the requested field value.

EXTRACT(date_tokens FROM date_column)

Required. One or more tokens representing the portions of date to be extracted, as determined by one or more of the strings shown in the table below.

Required. A column that is declared as a date_class datatype. The date_class datatypes are any of the date or time oriented datatypes found in the list of Omnidex datatypes.

> select birthdate, extract(month from birthdate) mon from individuals;

BIRTHDATE     MON
------------  -----------
  1938-07-14            7
  1957-11-22           11
  1960-07-28            7
  1929-08-22            8
  1933-07-09            7
  1944-08-01            8
  2004-09-14            9

> select $random(12345) rnd from $omnidex;

RND
-----------
 1255939488

See also:

###

select status,
extract(mmm FROM orders.order_date)
from orders 
where product_no='PRN4356'

ORDR   JANUARY
ORDR   DECEMBER
CNCL   MARCH