Extraction function 

An extraction function is a function that extracts part of a date value, time value, or timestamp value or calculates a date, time, or timestamp.

Syntax

<extraction function> ::=
  YEAR        ( <date or timestamp expression> )
| MONTH       ( <date or timestamp expression> )
| DAY         ( <date or timestamp expression> )
| HOUR        ( <time or timestamp expression> )
| MINUTE      ( <time or timestamp expression> )
| SECOND      ( <time or timestamp expression> )
| MICROSECOND ( <expression> )
| TIMESTAMP   ( <expression>[, <expression> ] )
| DATE        ( <expression> )
| TIME        ( <expression> )

date or timestamp expression, time or timestamp expression, expression

YEAR(t), MONTH(t), DAY(t), HOUR(t), MINUTE(t), SECOND(t), MICROSECOND(a), TIMESTAMP(a,b), DATE(a), TIME(a)

A variety of date and time formats (ISO, USA, EUR, JIS, INTERNAL) are available for processing date and time values.