DuckDB - Date Functions

Documentation

Installation
Data Import

Client APIs

SQL

Introduction
Statements

Overview

Select

Insert

Delete

Update

Create Table

Create View

Create Sequence

Drop

Alter Table

Copy

Data Types

Overview

Boolean

Numeric

Text

Date

Timestamp

Expressions

Overview

Logical

Comparisons

Casting

Case

Collations

Subqueries

Functions

Overview

Numeric Functions

Text Functions

Pattern Matching

Date Functions

Timestamp Functions

Why DuckDB
FAQ

Date Functions

This section describes functions and operators for examining and manipulating date values.

Function	Description	Example	Result
`date_part(``part``,` `date``)`	Get subfield (equivalent to extract)	`date_part('year', DATE '1992-09-20')`	1992
`extract(``part` `from` `date``)`	Get subfield from a date	`extract('year' FROM DATE '1992-09-20')`	1992