Dates & time Scalar

date_part()

Get subfield (equivalent to extract)

Arguments & returns

14 overloads

Scalar

Overload link	`ts`	`col1`	Returns
#01	`VARCHAR`	`DATE`	`BIGINT`
#02	`VARCHAR`	`INTERVAL`	`BIGINT`
#03	`VARCHAR`	`TIME`	`BIGINT`
#04	`VARCHAR`	`TIME WITH TIME ZONE`	`BIGINT`
#05	`VARCHAR`	`TIME_NS`	`BIGINT`
#06	`VARCHAR`	`TIMESTAMP`	`BIGINT`
#07	`VARCHAR`	`TIMESTAMP WITH TIME ZONE`	`BIGINT`
#08	`VARCHAR[]`	`DATE`	`STRUCT()`
#09	`VARCHAR[]`	`INTERVAL`	`STRUCT()`
#10	`VARCHAR[]`	`TIME`	`STRUCT()`
#11	`VARCHAR[]`	`TIME WITH TIME ZONE`	`STRUCT()`
#12	`VARCHAR[]`	`TIME_NS`	`STRUCT()`
#13	`VARCHAR[]`	`TIMESTAMP`	`STRUCT()`
#14	`VARCHAR[]`	`TIMESTAMP WITH TIME ZONE`	`STRUCT()`

SELECT date_part('minute', TIMESTAMP '1992-09-20 20:38:40');

Haybarn WASM 1.5.5-rc3 · In your browser

Engine example · Run to view results.