Glossary: PostgreSQL for Developers

extract

A function that pulls one part of a date or time out as a number, such as extract(hour FROM placed_at).