Da muß ich Mr. Spock beipflichten... Hier ist nochmal eine Kurzbeschreibung der Function:
Zitat:
The EXTRACT() function extracts date and time information from databases.
EXTRACT() has the following syntax:
EXTRACT ( part FROM value)
The value passed to the EXTRACT() expression must be DATE, TIME, or TIMESTAMP. Extracting a part that doesn't exist in a datatype results in an error. For example:
EXTRACT (TIME FROM aTime)
A statement such as EXTRACT (YEAR from aTime) would fail.