Eine Einführung in


Components of a date: such as the year or the month

We can extract the year, the month, the day of the month and the day of the week. Times may be extracted in a similar way. The SQL Standard specifies the understandably unpopular EXTRACT function.

Specific to PostgreSQL
In addition to the standard postgres supports the DATE_PART function.