functions_datetime.yaml¶
This document file is generated for functions_datetime.yaml
Scalar Functions¶
extract¶
Implementations:
extract(component
, x
): -> return_type
0. extract(component
, timestamp
): -> i64
1. extract(component
, timestamp_tz
): -> i64
2. extract(component
, date
): -> i64
3. extract(component
, time
): -> i64
Extract portion of a date/time value.
Options:
add¶
Implementations:
add(x
, y
): -> return_type
0. add(timestamp
, interval_year
): -> timestamp
1. add(timestamp_tz
, interval_year
): -> timestamp
2. add(date
, interval_year
): -> timestamp
3. add(timestamp
, interval_day
): -> timestamp
4. add(timestamp_tz
, interval_day
): -> timestamp
5. add(date
, interval_day
): -> timestamp
Add an interval to a date/time type.
add_intervals¶
Implementations:
add_intervals(x
, y
): -> return_type
0. add_intervals(interval_day
, interval_day
): -> interval_day
1. add_intervals(interval_year
, interval_year
): -> interval_year
Add two intervals together.
subtract¶
Implementations:
subtract(x
, y
): -> return_type
0. subtract(timestamp
, interval_year
): -> timestamp
1. subtract(timestamp_tz
, interval_year
): -> timestamp_tz
2. subtract(date
, interval_year
): -> date
3. subtract(timestamp
, interval_day
): -> timestamp
4. subtract(timestamp_tz
, interval_day
): -> timestamp_tz
5. subtract(date
, interval_day
): -> date
Subtract an interval from a date/time type.
lte¶
Implementations:
lte(x
, y
): -> return_type
0. lte(timestamp
, timestamp
): -> boolean
1. lte(timestamp_tz
, timestamp_tz
): -> boolean
2. lte(date
, date
): -> boolean
3. lte(interval_day
, interval_day
): -> boolean
4. lte(interval_year
, interval_year
): -> boolean
less than or equal to
lt¶
Implementations:
lt(x
, y
): -> return_type
0. lt(timestamp
, timestamp
): -> boolean
1. lt(timestamp_tz
, timestamp_tz
): -> boolean
2. lt(date
, date
): -> boolean
3. lt(interval_day
, interval_day
): -> boolean
4. lt(interval_year
, interval_year
): -> boolean
less than
gte¶
Implementations:
gte(x
, y
): -> return_type
0. gte(timestamp
, timestamp
): -> boolean
1. gte(timestamp_tz
, timestamp_tz
): -> boolean
2. gte(date
, date
): -> boolean
3. gte(interval_day
, interval_day
): -> boolean
4. gte(interval_year
, interval_year
): -> boolean
greater than or equal to
gt¶
Implementations:
gt(x
, y
): -> return_type
0. gt(timestamp
, timestamp
): -> boolean
1. gt(timestamp_tz
, timestamp_tz
): -> boolean
2. gt(date
, date
): -> boolean
3. gt(interval_day
, interval_day
): -> boolean
4. gt(interval_year
, interval_year
): -> boolean
greater than