Extract functions
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 |
, multiple selections available,