[erledigt] sql: extract verständnisproblem

[Domo Sokrat]

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.