# EXTRACT ## Definition(s) ### Context: [[Nexus - Google Analytics Certificate Course#5.4 Google Analytics - 5 Analyze - Module 4 - Perform data calculations Perform Data Calculations|Google Analytics Certificate]] #### Sub-context: [[SQL Function]] >[! Definition] >Let's us pull one part of a given date to use ## Examples ```SQL SELECT EXTRACT(datetime_part FROM timestamp_expr [AT TIME ZONE tz_spec]) FROM db.tbl ``` ## Related ## Resources ## Flashcards The below code are generated for use with [Spaced Repetition plugin](https://github.com/st3v3nmw/obsidian-spaced-repetition/) [docs](https://www.stephenmwangi.com/obsidian-spaced-repetition/)