Extract functions return individual field values (e.g., hour, minute, name of month, weekday name) from a variable of one of the timeseries data types. The extract functions are:

extract_dt
extract_i
extract_tm
extract_ts

Summary

These functions perform perform basic extraction of timeseries field values.

This table shows the valid values of string parameters you can extract with the extract_ functions:

Time Unit	String	Available Extract Functions
Year	year	extract_ts, extract_dt
Month	mon	extract_ts, extract_dt
Day	day	extract_ts, extract_dt, extract_i
Hour	hour	extract_ts, extract_tm, extract_i
Min	min	extract_ts, extract_tm, extract_i
Sec	sec	extract_ts, extract_tm, extract_i
Millisecond	ms	extract_ts, extract_tm, extract_i
Microsecond	us (or mcs)	extract_ts, extract_tm, extract_i
Julian date	yday	extract_ts, extract_dt
Weekday	wday	extract_ts, extract_dt

SciDB Documentation 19.11

Extract functions

Analytics

Summary

Related content