EXTRACT

The EXTRACT function returns a specified portion of a datetime value.

Extract Date Values


>>-EXTRACT--(--+-YEAR--+--FROM--+-date-expression------+--)----><
               +-MONTH-+        '-timestamp-expression-'      
               '-DAY---'

Extract Time Values


>>-EXTRACT--(--+-HOUR---+--FROM--+-time-expression------+--)---><
               +-MINUTE-+        '-timestamp-expression-'      
               '-SECOND-'

Extract Date Values

YEAR: Specifies that the year portion of the date or timestamp expression is returned. The result is identical to the YEAR scalar function. For more information, see YEAR.
MONTH: Specifies that the month portion of the date or timestamp expression is returned. The result is identical to the MONTH scalar function. For more information, see MONTH.
DAY: Specifies that the day portion of the date or timestamp expression is returned. The result is identical to the DAY scalar function. For more information, see DAY.
date-expression: An expression that returns the value of either a built-in date or built-in character or graphic string data type.
If expression is a character or graphic string, it must not be a CLOB or DBCLOB and its value must be a valid character-string or graphic-string representation of a date. For the valid formats of string representations of dates, see String representations of datetime values.
timestamp-expression: An expression that returns the value of either a built-in timestamp or built-in character or graphic string data type.
If expression is a character or graphic string, it must not be a CLOB or DBCLOB and its value must be a valid character-string or graphic-string representation of a timestamp. For the valid formats of string representations of timestamps, see String representations of datetime values.

Extract Time Values

HOUR

Specifies that the hour portion of the time or timestamp expression is returned. The result is identical to the HOUR scalar function. For more information, see HOUR.

MINUTE

Specifies that the minute portion of the time or timestamp expression is returned. The result is identical to the MINUTE scalar function. For more information, see MINUTE.

SECOND

Specifies that the second portion of the time or timestamp expression is returned. If the expression is a timestamp-expression, the result is identical to the following:

DECIMAL((SECOND(expression) + DECIMAL(MICROSECOND(expression),12,6)/1000000), 8,6)

If the expression is a time-expression, the result is identical to the following:

DECIMAL((SECOND(expression), 8,6)

For more information, see SECOND and MICROSECOND. End of change

time-expression

An expression that returns the value of either a built-in time or built-in character Start of change

or graphic End of change

string data type.

If expression is a character or graphic string, it must not be a CLOB Start of change or DBCLOB and its value must be a valid character-string or graphic-string End of change representation of a time. For the valid formats of string representations of times, see String representations of datetime values.

timestamp-expression

An expression that returns the value of either a built-in timestamp or built-in character Start of change

or graphic End of change

string data type.

If expression is a character or graphic string, it must not be a CLOB Start of change or DBCLOB and its value must be a valid character-string or graphic-string End of change representation of a timestamp. For the valid formats of string representations of timestamps, see String representations of datetime values.

The data type of the result of the function depends on the part of the datetime value that is specified:

If YEAR, MONTH, DAY, HOUR, or MINUTE is specified, the data type of the result is INTEGER.
If SECOND is specified, the data type of the result is DECIMAL(8,6). The fractional digits contains microseconds.

If the argument can be null, the result can be null; if the argument is null, the result is the null value.

Examples

Assume the column PRSTDATE has an internal value equivalent to 1988-12-25.
```
  SELECT EXTRACT( MONTH FROM PRSTDATE )
    FROM PROJECT
```
Results in the value 12.