Results of 1 - 10 of about 122 for Description (0.005 sec.)
- Spatial Functions 10164
- Function Index Scalar Functions Function Summary DuckDB_PROJ_Compiled_Version Returns a text description of the PROJ library version that this instance of DuckDB was compiled against. DuckDB_Proj_Version Returns a text description of the PR
...ts using the GDAL library. Scalar Functions DuckDB_PROJ_Compiled_Version Signature VARCHAR DuckDB_PROJ_Compiled_Version () Description Returns a text description of the PROJ library version that this instance of DuckDB was compiled against. Example SELECT d....1.1, December 1st, 2022 │ └────────────────────────────────┘ DuckDB_Proj_Version Signature VARCHAR DuckDB_Proj_Version () Description Returns a text description of the PROJ library version that is being used by this instance of DuckDB. Example SELECT duckd...DOUBLE, zoff DOUBLE) GEOMETRY ST_Affine (geom GEOMETRY, a DOUBLE, b DOUBLE, d DOUBLE, e DOUBLE, xoff DOUBLE, yoff DOUBLE) Description Applies an affine transformation to a geometry. For the 2D variant, the transformation matrix is defined as follows: | a b... - https://man.mtool.work/duckdb/2.0/core_extensions/spatial/functions.html
- Numeric Functions 9830
- Numeric Operators The table below shows the available mathematical operators for numeric types . Operator Description Example Result + Addition 2 + 3 5 - Subtraction 2 - 3 -1 * Multiplication 2 * 3 6 / Float division 5 / 2 2.5 // Division 5
...e available for all numeric data types. Numeric Functions The table below shows the available mathematical functions. Name Description @(x) Absolute value. Parentheses are optional if x is a column name. abs(x) Absolute value. acos(x) Computes the inverse c...tangent of x . tanh(x) Computes the hyperbolic tangent of x . trunc(x) Truncates the number. xor(x, y) Bitwise XOR. @(x) | Description | Absolute value. Parentheses are optional if x is a column name. | | Example | @(-17.4) | | Result | 17.4 | | Alias | abs...| abs(x) | Description | Absolute value. | | Example | abs(-17.4) | | Result | 17.4 | | Alias | @ | acos(x) | Description | Computes the inverse... - https://man.mtool.work/duckdb/2.0/sql/functions/numeric.html
- Text Functions 9632
- Text Functions and Operators This section describes functions and operators for examining and manipulating STRING values . Function Description string[index] Extracts a single character using a (1-based) index . string[begin:end] Extracts a
...ion using Percent-Encoding . url_encode(string) Encodes a URL to a representation using Percent-Encoding . string[index] | Description | Extracts a single character using a (1-based) index . | | Example | 'DuckDB'[4] | | Result | k | | Alias | array_extract...| string[begin:end] | Description | Extracts a string using slice conventions similar to Python. Missing begin or end arguments are interpreted as the begin...Negative values are accepted. | | Example | 'DuckDB'[:4] | | Result | Duck | | Alias | array_slice | string LIKE target | Description | Returns true if the string matches the like specifier (see Pattern Matching ). | | Example | 'hello' LIKE '%lo' | | Resu... - https://man.mtool.work/duckdb/2.0/sql/functions/text.html
- Utility Functions 9545
- Scalar Utility Functions The functions below are difficult to categorize into specific function types and are broadly useful. Name Description alias(column) Return the name of the column. can_cast_implicitly(source_value, target_value) Whet
...Extracts UUID version ( 4 or 7 ). version() Return the currently active version of DuckDB in this format. alias(column) | Description | Return the name of the column. | | Example | alias(column1) | | Result | column1 | can_cast_implicitly(source_value, tar...get_value) | Description | Whether or not we can implicitly cast from the types of the source value to the target value. | | Example | can_cast_imp...licitly(1::BIGINT, 1::SMALLINT) | | Result | false | checkpoint(database) | Description | Synchronize WAL with file for (optional) database without interrupting transactions. | | Example | checkpoint(my_db) | |... - https://man.mtool.work/duckdb/2.0/sql/functions/utility.html
- Aggregate Functions 9385
- Examples Produce a single row containing the sum of the amount column: SELECT sum(amount) FROM sales; Produce one row per unique region, containing the sum of amount for each group: SELECT region, sum(amount) FROM sales GROUP BY region; Ret
...string in this case. General Aggregate Functions The table below shows the available general aggregate functions. Function Description any_value(arg) Returns the first non-null value from arg . This function is affected by ordering . arg_max(arg, val) Finds...If weight is NULL , the corresponding arg value will be skipped. This function is affected by ordering . any_value(arg) | Description | Returns the first non- NULL value from arg . This function is affected by ordering . | | Example | any_value(A) | arg_ma...x(arg, val) | Description | Finds the row with the maximum val and calculates the arg expression at that row. Rows where the value of the arg or val... - https://man.mtool.work/duckdb/2.0/sql/functions/aggregates.html
- List Functions 9347
- Function Description list[index] Extracts a single list element using a (1-based) index . list[begin[:end][:step]] Extracts a sublist using slice conventions . Negative values are accepted. list1 && list2 Alias for list_has_any . list1 <->
...unpivot_list(arg, ...) Identical to list_value, but generated as part of unpivot for better error messages. list[index] | Description | Extracts a single list element using a (1-based) index . | | Example | [4, 5, 6][3] | | Result | 6 | | Alias | list_extr...act | list[begin[:end][:step]] | Description | Extracts a sublist using slice conventions . Negative values are accepted. | | Example | [4, 5, 6][3] | | Result | 6 | |...Alias | list_slice | arg1 || arg2 | Description | Concatenates two strings, lists, or blobs. Any NULL input results in NULL . See also concat(arg1, arg2, ...) and list_co... - https://man.mtool.work/duckdb/2.0/sql/functions/list.html
- Date Part Functions 9125
- The date_part , date_trunc and date_diff functions can be used to extract or manipulate parts of temporal types such as TIMESTAMP , TIMESTAMPTZ , DATE and INTERVAL . The parts to be extracted or manipulated are specified by one of the strin
...DB, NULL s are returned for infinite timestamps. Part Specifiers Usable as Date Part Specifiers and in Intervals Specifier Description Synonyms Example century Gregorian century cent , centuries , c 21 day Gregorian day days , d , dayofmonth 3 decade Gregor..., secs , s 44 year Gregorian year yr , y , years , yrs 2021 Part Specifiers Only Usable as Date Part Specifiers Specifier Description Synonyms Example dayofweek Day of the week (Sunday = 0, Saturday = 6) weekday , dow 2 dayofyear Day of the year (1-365/366...support TIMESTAMP WITH TIME ZONE . Part Functions There are dedicated extraction functions to get certain subfields: Name Description century(date) Century. day(date) Day. dayofmonth(date) Day (synonym). dayofweek(date) Numeric weekday (Sunday = 0, Saturda... - https://man.mtool.work/duckdb/2.0/sql/functions/datepart.html
- Timestamp Functions 9100
- This section describes functions and operators for examining and manipulating TIMESTAMP values . See also the related TIMESTAMPTZ functions . Timestamp Operators The table below shows the available mathematical operators for TIMESTAMP types
.... Operator Description Example Result + addition of an INTERVAL TIMESTAMP '1992-03-22 01:02:03' + INTERVAL 5 DAY 1992-03-27 01:02:03 - subtractio...infinite value. Scalar Timestamp Functions The table below shows the available scalar functions for TIMESTAMP values. Name Description age(timestamp, timestamp) Subtract arguments, resulting in the time difference between the two timestamps. age(timestamp)...al, if the function needs to examine the parts of the infinite date, the result will be NULL . age(timestamp, timestamp) | Description | Subtract arguments, resulting in the time difference between the two timestamps. | | Example | age(TIMESTAMP '2001-04-10... - https://man.mtool.work/duckdb/2.0/sql/functions/timestamp.html
- Timestamp with Time Zone Functions 9038
- This section describes functions and operators for examining and manipulating TIMESTAMP WITH TIME ZONE (or TIMESTAMPTZ ) values . See also the related TIMESTAMP functions . Time zone support is provided by the built-in ICU extension . In th
...functions for TIMESTAMPTZ values. Since these functions do not involve binning or display, they are always available. Name Description current_timestamp Current date and time (start of current transaction). get_current_timestamp() Current date and time (sta...imestamp with time zone. transaction_timestamp() Current date and time (start of current transaction). current_timestamp | Description | Current date and time (start of current transaction). | | Example | current_timestamp | | Result | 2022-10-08 12:44:46.1...22-07 | get_current_timestamp() | Description | Current date and time (start of current transaction). | | Example | get_current_timestamp() | | Result | 2022-10-08 12:4... - https://man.mtool.work/duckdb/2.0/sql/functions/timestamptz.html
- Interval Functions 8927
- This section describes functions and operators for examining and manipulating INTERVAL values. Interval Operators The table below shows the available mathematical operators for INTERVAL types. Operator Description Example Result + Addition
...INTERVAL 5 HOUR 01:02:03 Interval Functions The table below shows the available scalar functions for INTERVAL types. Name Description date_part(part, interval) Extract datepart component (equivalent to extract ). See INTERVAL for the sometimes surprising r...Construct a year interval. Only the documented date part components are defined for intervals. date_part(part, interval) | Description | Extract datepart component (equivalent to extract ). See INTERVAL for the sometimes surprising rules governing this extr...action. | | Example | date_part('year', INTERVAL '14 months') | | Result | 1 | datepart(part, interval) | Description | Alias of date_part . | | Example | datepart('year', INTERVAL '14 months') | | Result | 1 | extract(part FROM interval) |... - https://man.mtool.work/duckdb/2.0/sql/functions/interval.html
DuckDB 2.0 Documentation / man.mtool.work