Results of 1 - 7 of about 7 for greatest (0.005 sec.)
- Numeric Functions – DuckDB 13250
- 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
...s a DOUBLE value. gamma(x) Interpolation of the factorial of x - 1 . Fractional inputs are allowed. gcd(x, y) Computes the greatest common divisor of x and y . greatest_common_divisor(x, y) Computes the greatest common divisor of x and y . greatest(x1, x...l of x - 1 . Fractional inputs are allowed. Example gamma(5.5) Result 52.34277778455352 gcd(x, y) Description Computes the greatest common divisor of x and y . Example gcd(42, 57) Result 3 greatest_common_divisor(x, y) Description Computes the greatest c...ommon divisor of x and y . Example greatest_common_divisor(42, 57) Result 3 greatest(x1, x2, ...) Description Selects the largest value. Example greatest(3, 2, 4, 4)... - https://man.mtool.work/duckdb/1.3/sql/functions/numeric.html
- Date Functions – DuckDB 9324
- 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
.... Alias of date_trunc . dayname(date) The (English) 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) Return...y extract(part from date) Description Get subfield from a date. Example extract('year' FROM DATE '1992-09-20') Result 1992 greatest(date, date) Description The later of two dates. Example greatest(DATE '1992-09-20', DATE '1992-03-07') Result 1992-09-20 i...or the day of the week from a date. 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 sense”. In general, if the function needs to examine the parts of th... - https://man.mtool.work/duckdb/1.3/sql/functions/date.html
- Timestamp Functions – DuckDB 8924
- 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
...mestamp) Returns the total number of seconds since the epoch. 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 othe...ion 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 sense”. In general, if the function needs to examine the parts of th...mestamp) Description Get subfield from a timestamp. Example extract('hour' FROM TIMESTAMP '1992-09-20 20:38:48') Result 20 greatest(timestamp, timestamp) Description The later of two timestamps. Example greatest(TIMESTAMP '1992-09-20 20:38:48', TIMESTAMP... - https://man.mtool.work/duckdb/1.3/sql/functions/timestamp.html
- Timestamp with Time Zone Functions – DuckDB 8797
- 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
...ate and time (start of current transaction). get_current_timestamp() 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...on Current date and time (start of current transaction). Example get_current_timestamp() Result 2022-10-08 12:44:46.122-07 greatest(timestamptz, timestamptz) Description The later of two timestamps. Example greatest(TIMESTAMPTZ '1992-09-20 20:38:48', TIM...: Unknown TimeZone '0200' Infinities 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 sense”. In general, if the function needs to examine the parts of th... - https://man.mtool.work/duckdb/1.3/sql/functions/timestamptz.html
- Text Functions – DuckDB 8106
- 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
...a value from binary representation to a blob. from_hex(value) Converts a value from hexadecimal representation to a blob. greatest(arg1, ...) Returns the largest value in lexicographical order. Note that lowercase characters are considered larger than u...value) Description Converts a value from hexadecimal representation to a blob. Example from_hex('2A') Result * Alias unhex greatest(arg1, ...) Description Returns the largest value in lexicographical order. Note that lowercase characters are considered l...arger than uppercase characters and collations are not supported. Example 1 greatest(42, 84) Result 84 Example 2 greatest('abc', 'bcd', 'cde', 'EFG') Result cde hash(value, ...) Description Returns a UBIGINT... - https://man.mtool.work/duckdb/1.3/sql/functions/text.html
- SQL Quirks – DuckDB 7561
- 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
...ate IEEE-754 but mean floating point data types have a total order, like all other data types (beware the consequences for greatest / least ). age Function age(x) is current_date - x instead of current_timestamp - x . Another quirk inherited from Postgre... - https://man.mtool.work/duckdb/1.3/sql/dialect/sql_quirks.html
- Aggregate Functions – DuckDB 7561
- 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
...orresponding interpolated quantiles. quantile_disc(x, pos) The discrete pos -quantile of x for 0 <= pos <= 1 . Returns the greatest(ceil(pos * n_nonnull_values) - 1, 0) th (zero-indexed, in the specified order) value of x . Intuitively, assigns to each v...s. Formula - Alias(es) - quantile_disc(x, pos) Description The discrete pos -quantile of x for 0 <= pos <= 1 . Returns the greatest(ceil(pos * n_nonnull_values) - 1, 0) th (zero-indexed, in the specified order) value of x . Intuitively, assigns to each v... - https://man.mtool.work/duckdb/1.3/sql/functions/aggregates.html
PREV
1
NEXT
DuckDB 1.3 Documentation / man.mtool.work