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.

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