Results of 1 - 7 of about 7 for finite (0.301 sec.)
- Types – DuckDB 13195
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
..._date_struct duckdb_from_date ( duckdb_date date ); duckdb_date duckdb_to_date ( duckdb_date_struct date ); bool duckdb_is_finite_date ( duckdb_date date ); duckdb_time_struct duckdb_from_time ( duckdb_time time ); duckdb_time_tz duckdb_create_time_tz...rom_timestamp ( duckdb_timestamp ts ); duckdb_timestamp duckdb_to_timestamp ( duckdb_timestamp_struct ts ); bool duckdb_is_finite_timestamp ( duckdb_timestamp ts ); bool duckdb_is_finite_timestamp_s ( duckdb_timestamp_s ts ); bool duckdb_is_finite_time...stamp_ms ( duckdb_timestamp_ms ts ); bool duckdb_is_finite_timestamp_ns ( duckdb_timestamp_ns ts ); Hugeint Helpers double duckdb_hugeint_to_double ( duckdb_hugeint val ); duckdb_hu... - https://man.mtool.work/duckdb/1.3/clients/c/types.html
- Complete API – DuckDB 10033
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
..._date_struct duckdb_from_date ( duckdb_date date ); duckdb_date duckdb_to_date ( duckdb_date_struct date ); bool duckdb_is_finite_date ( duckdb_date date ); duckdb_time_struct duckdb_from_time ( duckdb_time time ); duckdb_time_tz duckdb_create_time_tz...rom_timestamp ( duckdb_timestamp ts ); duckdb_timestamp duckdb_to_timestamp ( duckdb_timestamp_struct ts ); bool duckdb_is_finite_timestamp ( duckdb_timestamp ts ); bool duckdb_is_finite_timestamp_s ( duckdb_timestamp_s ts ); bool duckdb_is_finite_time...stamp_ms ( duckdb_timestamp_ms ts ); bool duckdb_is_finite_timestamp_ns ( duckdb_timestamp_ns ts ); Hugeint Helpers double duckdb_hugeint_to_double ( duckdb_hugeint val ); duckdb_hu... - https://man.mtool.work/duckdb/1.3/clients/c/api.html
- Date Functions – DuckDB 8197
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...L (d.days) DAY FROM (VALUES (5), (11)) d(days) 1992-03-22 00:00:00 and 1992-03-16 00:00:00 Adding to or subtracting from infinite values produces the same infinite value. Date Functions The table below shows the available functions for DATE types. Date...ish) name of the weekday. extract(part from date) Get subfield from a date. greatest(date, date) The later of two dates. isfinite(date) Returns true if the date is finite, false otherwise. isinf(date) Returns true if the date is infinite, false otherwi...date, date) Description The later of two dates. Example greatest(DATE '1992-09-20', DATE '1992-03-07') Result 1992-09-20 isfinite(date) Description Returns true if the date is finite, false otherwise. Example isfinite(DATE '1992-03-07') Result true isi... - https://man.mtool.work/duckdb/1.3/sql/functions/date.html
- Numeric Functions – DuckDB 8142
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
..._common_divisor(x, y) Computes the greatest common divisor of x and y . greatest(x1, x2, ...) Selects the largest value. isfinite(x) Returns true if the floating point value is finite, false otherwise. isinf(x) Returns true if the floating point value...is infinite, false otherwise. isnan(x) Returns true if the floating point value is not a number, false otherwise. lcm(x, y) Computes t...isor(42, 57) Result 3 greatest(x1, x2, ...) Description Selects the largest value. Example greatest(3, 2, 4, 4) Result 4 isfinite(x) Description Returns true if the floating point value is finite, false otherwise. Example isfinite(5.5) Result true isin... - https://man.mtool.work/duckdb/1.3/sql/functions/numeric.html
- Timestamp Functions – DuckDB 8070
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...action of an INTERVAL TIMESTAMP '1992-03-27 01:02:03' - INTERVAL 5 DAY 1992-03-22 01:02:03 Adding to or subtracting from infinite values produces the same infinite value. Scalar Timestamp Functions The table below shows the available scalar functions f...extract(field FROM timestamp) Get subfield from a timestamp. greatest(timestamp, timestamp) The later of two timestamps. isfinite(timestamp) Returns true if the timestamp is finite, false otherwise. isinf(timestamp) Returns true if the timestamp is inf...ing . Returns NULL on failure. There are also dedicated extraction functions to get the subfields . Functions applied to infinite dates will either return the same infinite dates (e.g., greatest ) or NULL (e.g., date_part ) depending on what “makes sen... - https://man.mtool.work/duckdb/1.3/sql/functions/timestamp.html
- Timestamp with Time Zone Functions – DuckDB 8070
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...() Current date and time (start of current transaction). greatest(timestamptz, timestamptz) The later of two timestamps. isfinite(timestamptz) Returns true if the timestamp with time zone is finite, false otherwise. isinf(timestamptz) Returns true if t...he timestamp with time zone is infinite, false otherwise. least(timestamptz, timestamptz) The earlier of two timestamps. now() Current date and time (start of cur...xample greatest(TIMESTAMPTZ '1992-09-20 20:38:48', TIMESTAMPTZ '1992-03-22 01:02:03.1234') Result 1992-09-20 20:38:48-07 isfinite(timestamptz) Description Returns true if the timestamp with time zone is finite, false otherwise. Example isfinite(TIMESTA... - https://man.mtool.work/duckdb/1.3/sql/functions/timestamptz.html
- Numeric Types – DuckDB 7852
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...maximal supported WIDTH , which is currently 38. Division of fixed-point decimals does not typically produce numbers with finite decimal expansion. Therefore, DuckDB uses approximate floating-point arithmetic for all divisions that involve fixed-point... - https://man.mtool.work/duckdb/1.3/sql/data_types/numeric.html
PREV
1
NEXT
DuckDB 1.3 Documentation / man.mtool.work