Dates & time Scalar

datepart()

Get subfield (equivalent to extract)

Reference: DuckDB 2.0.0

Arguments & returns

14 overloads

datepart(part_list, ts)

Scalar
Overload link part_listts Returns
#01 VARCHAR[]DATE STRUCT
#02 VARCHAR[]INTERVAL STRUCT
#03 VARCHAR[]TIME STRUCT
#04 VARCHAR[]TIME WITH TIME ZONE STRUCT
#05 VARCHAR[]TIME_NS STRUCT
#06 VARCHAR[]TIMESTAMP STRUCT
#07 VARCHAR[]TIMESTAMP WITH TIME ZONE STRUCT

datepart(part, ts)

Scalar
Overload link partts Returns
#08 VARCHARDATE DOUBLE
#09 VARCHARINTERVAL DOUBLE
#10 VARCHARTIME DOUBLE
#11 VARCHARTIME WITH TIME ZONE DOUBLE
#12 VARCHARTIME_NS DOUBLE
#13 VARCHARTIMESTAMP DOUBLE
#14 VARCHARTIMESTAMP WITH TIME ZONE DOUBLE

Example

datepart example
SQL
Haybarn WASM 2.0.0-rc12 ยท In your browser

Engine example ยท Run to view results.