Results of 1 - 10 of about 370 for between (0.005 sec.)
- Comparisons – DuckDB 10026
- 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
...) Overview ODBC Overview Linux Setup Windows Setup macOS Setup Configuration PHP Python Overview Data Ingestion Conversion between DuckDB and Python DB API Relational API Function API Types API Expression API Spark API API Reference Known Python Issues...e stricter type-checking, we recommend creating a macro with the typeof function or implementing a user-defined function . BETWEEN and IS [NOT] NULL Besides the standard comparison operators there are also the BETWEEN and IS (NOT) NULL operators. These...ve much like operators, but have special syntax mandated by the SQL standard. They are shown in the table below. Note that BETWEEN and NOT BETWEEN are only equivalent to the examples below in the cases where both a , x and y are of the same type, as BET... - https://man.mtool.work/duckdb/1.3/sql/expressions/comparison_operators.html
- Array Functions – DuckDB 10026
- 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
...) Overview ODBC Overview Linux Setup Windows Setup macOS Setup Configuration PHP Python Overview Data Ingestion Conversion between DuckDB and Python DB API Relational API Function API Types API Expression API Spark API API Reference Known Python Issues...rays of size 3. The array elements can not be NULL . array_cosine_similarity(array1, array2) Compute the cosine similarity between two arrays of the same size. The array elements can not be NULL . The arrays can have any size as long as the size is the...same for both arguments. array_cosine_distance(array1, array2) Compute the cosine distance between two arrays of the same size. The array elements can not be NULL . The arrays can have any size as long as the size is the... - https://man.mtool.work/duckdb/1.3/sql/functions/array.html
- Spatial Functions – DuckDB 9524
- 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
...) Overview ODBC Overview Linux Setup Windows Setup macOS Setup Configuration PHP Python Overview Data Ingestion Conversion between DuckDB and Python DB API Relational API Function API Types API Expression API Spark API API Reference Known Python Issues...erageSimplify Simplify the edges in a polygonal coverage, preserving the coverange by ensuring that the there are no seams between the resulting simplified polygons. ST_CoverageUnion Union all geometries in a polygonal coverage into a single geometry. S...ithin a target distance in meters, using an ellipsoidal model of the earths surface ST_Difference Returns the "difference" between two geometries ST_Dimension Returns the "topological dimension" of a geometry. ST_Disjoint Returns true if the geometries... - https://man.mtool.work/duckdb/1.3/core_extensions/spatial/functions.html
- Time Functions – DuckDB 9524
- 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
...) Overview ODBC Overview Linux Setup Windows Setup macOS Setup Configuration PHP Python Overview Data Ingestion Conversion between DuckDB and Python DB API Relational API Function API Types API Expression API Spark API API Reference Known Python Issues...rentheses should be omitted from the function call. date_diff(part, starttime, endtime) The number of partition boundaries between the times. date_part(part, time) Get subfield (equivalent to extract ). date_sub(part, starttime, endtime) The number of c...omplete partitions between the times. datediff(part, starttime, endtime) Alias of date_diff . The number of partition boundaries between the times. d... - https://man.mtool.work/duckdb/1.3/sql/functions/time.html
- Date Functions – DuckDB 8211
- 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
...) Overview ODBC Overview Linux Setup Windows Setup macOS Setup Configuration PHP Python Overview Data Ingestion Conversion between DuckDB and Python DB API Relational API Function API Types API Expression API Spark API API Reference Known Python Issues...e interval to the date and return a DATETIME value. date_diff(part, startdate, enddate) The number of partition boundaries between the dates. date_part(part, date) Get the subfield (equivalent to extract ). date_sub(part, startdate, enddate) The number...of complete partitions between the dates. date_trunc(part, date) Truncate to specified precision . datediff(part, startdate, enddate) The number of parti... - https://man.mtool.work/duckdb/1.3/sql/functions/date.html
- Text Functions – DuckDB 8211
- 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
...) Overview ODBC Overview Linux Setup Windows Setup macOS Setup Configuration PHP Python Overview Data Ingestion Conversion between DuckDB and Python DB API Relational API Function API Types API Expression API Spark API API Reference Known Python Issues...malize(string) Converts string to Unicode NFC normalized string. Useful for comparisons and ordering if text data is mixed between NFC normalized and not. not_ilike_escape(string, like_specifier, escape_character) Returns false if the string matches the...g) Description Converts string to Unicode NFC normalized string. Useful for comparisons and ordering if text data is mixed between NFC normalized and not. Example nfc_normalize('ardèch') Result ardèch not_ilike_escape(string, like_specifier, escape_cha... - https://man.mtool.work/duckdb/1.3/sql/functions/text.html
- Timestamp Functions – DuckDB 8211
- 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
...) Overview ODBC Overview Linux Setup Windows Setup macOS Setup Configuration PHP Python Overview Data Ingestion Conversion between DuckDB and Python DB API Relational API Function API Types API Expression API Spark API API Reference Known Python Issues...ions for TIMESTAMP values. Name Description age(timestamp, timestamp) Subtract arguments, resulting in the time difference between the two timestamps. age(timestamp) Subtract from current_date. century(timestamp) Extracts the century of a timestamp. cur...urrent timestamp (at the start of the transaction). date_diff(part, startdate, enddate) The number of partition boundaries between the timestamps. date_part([part, ...], timestamp) Get the listed subfields as a struct . The list must be constant. date_p... - https://man.mtool.work/duckdb/1.3/sql/functions/timestamp.html
- Window Functions – DuckDB 7911
- 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
...) Overview ODBC Overview Linux Setup Windows Setup macOS Setup Configuration PHP Python Overview Data Ingestion Conversion between DuckDB and Python DB API Relational API Function API Types API Expression API Spark API API Reference Known Python Issues...artitioned by region : SELECT row_number () OVER ( PARTITION BY region ORDER BY time ) FROM sales ; Compute the difference between the current and the previous-by- time amount : SELECT amount - lag ( amount ) OVER ( ORDER BY time ) FROM sales ; Compute...ITION BY region ) FROM sales ; Syntax Window functions can only be used in the SELECT clause. To share OVER specifications between functions, use the statement's WINDOW clause and use the OVER window_name syntax. General-Purpose Window Functions The tab... - https://man.mtool.work/duckdb/1.3/sql/functions/window_functions.html
- Timestamp with Time Zone Functions – DuckDB 7718
- 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
...) Overview ODBC Overview Linux Setup Windows Setup macOS Setup Configuration PHP Python Overview Data Ingestion Conversion between DuckDB and Python DB API Relational API Function API Types API Expression API Spark API API Reference Known Python Issues...WITH TIME ZONE values. Name Description age(timestamptz, timestamptz) Subtract arguments, resulting in the time difference between the two timestamps. age(timestamptz) Subtract from current_date. date_diff(part, startdate, enddate) The number of partiti...on boundaries between the timestamps. date_part([part, ...], timestamptz) Get the listed subfields as a struct . The list must be constant. date... - https://man.mtool.work/duckdb/1.3/sql/functions/timestamptz.html
- Union Type – DuckDB 6810
- 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
...) Overview ODBC Overview Linux Setup Windows Setup macOS Setup Configuration PHP Python Overview Data Ingestion Conversion between DuckDB and Python DB API Relational API Function API Types API Expression API Spark API API Reference Known Python Issues...(or implicit, read on below!) UNION to UNION cast, like CAST(union_value(b := 2) AS UNION(a INTEGER, b INTEGER)) . Casting between Unions UNION types can be cast between each other if the source type is a “subset” of the target type. In other words, all...the source UNION must be present in the target UNION , and all the types of the matching tags must be implicitly castable between source and target. In essence, this means that UNION types are covariant with respect to their members. Ok Source Target C... - https://man.mtool.work/duckdb/1.3/sql/data_types/union.html
DuckDB 1.3 Documentation / man.mtool.work