Results of 1 - 9 of about 9 for Extracts (0.006 sec.)
- Text Functions – DuckDB 13930
- 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
...is section describes functions and operators for examining and manipulating STRING values . Name Description string[index] Extracts a single character using a (1-based) index. string[begin:end] Extracts a string using slice conventions similar to Python....NULL input results in NULL . See also concat(arg1, arg2, ...) and list_concat(list1, list2) . array_extract(string, index) Extracts a single character from a string using a (1-based) index . array_slice(list, begin, end) Extracts a sublist or substring u...ppercase characters are considered smaller than lowercase characters and collations are not supported. left(string, count) Extracts the left-most count characters. left_grapheme(string, count) Extracts the left-most count grapheme clusters. len(string) N... - https://man.mtool.work/duckdb/1.3/sql/functions/text.html
- JSON Processing Functions – DuckDB 9077
- 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
...Returns true if the supplied path exists in the json , and false otherwise. json_extract(json, path) json_extract_path -> Extracts JSON from json at the given path . If path is a LIST , the result will be a LIST of JSON . json_extract_string(json, path)...json_extract_path_text ->> Extracts VARCHAR from json at the given path . If path is a LIST , the result will be a LIST of VARCHAR . json_value(json, path) Ex...at the supplied path is not a scalar value, it will return NULL . Note that the arrow operator -> , which is used for JSON extracts, has a low precedence as it is also used in lambda functions . Therefore, you need to surround the -> operator with parent... - https://man.mtool.work/duckdb/1.3/data/json/json_functions.html
- Utility Functions – DuckDB 8987
- 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
...7 . uuidv7() Return a random UUIDv7 similar to this: 81964ebe-00b1-7e1d-b0f9-43c29b6fb8f5 . uuid_extract_timestamp(uuidv7) Extracts timestamp from a UUIDv7 value. uuid_extract_version(uuid) Extracts UUID version ( 4 or 7 ). version() Return the currently...to this: 81964ebe-00b1-7e1d-b0f9-43c29b6fb8f5 . Example uuidv7() Result various uuid_extract_timestamp(uuidv7) Description Extracts timestamp from a UUIDv7 value. Example uuid_extract_timestamp(uuidv7()) Result 2025-04-19 15:51:20.07+00 uuid_extract_vers...ion(uuid) Description Extracts UUID version ( 4 or 7 ). Example uuid_extract_version(uuidv7()) Result 7 version() Description Return the currently active... - https://man.mtool.work/duckdb/1.3/sql/functions/utility.html
- Bitstring Functions – DuckDB 8592
- 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
...ftmost) bit is indexed 1. bitstring(bitstring, length) Returns a bitstring of determined length. get_bit(bitstring, index) Extracts the nth bit from bitstring; the first (leftmost) bit is indexed 0. length(bitstring) Alias for bit_length . octet_length(b...tstring of determined length. Example bitstring('1010'::BITSTRING, 7) Result 0001010 get_bit(bitstring, index) Description Extracts the nth bit from bitstring; the first (leftmost) bit is indexed 0. Example get_bit('0110010'::BITSTRING, 2) Result 1 lengt... - https://man.mtool.work/duckdb/1.3/sql/functions/bitstring.html
- Timestamp Functions – DuckDB 8214
- 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
...resulting in the time difference between the two timestamps. age(timestamp) Subtract from current_date. century(timestamp) Extracts the century of a timestamp. current_localtimestamp() Returns the current timestamp (at the start of the transaction). date...rent_date. Example age(TIMESTAMP '1992-09-20') Result 29 years 1 month 27 days 12:39:00.844 century(timestamp) Description Extracts the century of a timestamp. Example century(TIMESTAMP '1992-03-22') Result 20 current_localtimestamp() Description Returns... - https://man.mtool.work/duckdb/1.3/sql/functions/timestamp.html
- Overview of DuckDB Internals – DuckDB 8124
- 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
...mming. Specifically, the DPccp algorithm from the paper Dynamic Programming Strikes Back is used. Common Sub Expressions : Extracts common subexpressions from projection and filter nodes to prevent unnecessary duplicate execution. In Clause Rewriter : Re... - https://man.mtool.work/duckdb/1.3/internals/overview.html
- Interval Type – DuckDB 8034
- 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
...this, the following query generates an INTERVAL called period by summing random amounts of the three basis units. It then extracts the aforementioned six parts from period , adds them back together, and confirms that the result is always equal to the or... - https://man.mtool.work/duckdb/1.3/sql/data_types/interval.html
- Spatial Functions – DuckDB 7927
- 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
...turns the centroid of a geometry ST_Collect Collects a list of geometries into a collection geometry. ST_CollectionExtract Extracts geometries from a GeometryCollection into a typed multi geometry. ST_ConcaveHull Returns the 'concave' hull of the input g..., 2 )), ( ST_Point ( 3 , 4 )); SELECT ST_Collect ( list ( geom )) FROM points ; ---- MULTIPOINT ( 1 2 , 3 4 ) ST_CollectionExtract Signatures GEOMETRY ST_CollectionExtract ( geom GEOMETRY , type INTEGER ) GEOMETRY ST_CollectionExtract ( geom GEOMETRY ) D...escription Extracts geometries from a GeometryCollection into a typed multi geometry. If the input geometry is a GeometryCollection, the funct... - https://man.mtool.work/duckdb/1.3/core_extensions/spatial/functions.html
- CSV Auto Detection – DuckDB 7927
- 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
...he values contain a DATE value for the FlightDate column. As such – the system defines the first row as the header row and extracts the column names from the header row. In files that do not have a header row, the column names are generated as column0 ,... - https://man.mtool.work/duckdb/1.3/data/csv/auto_detection.html
PREV
1
NEXT
DuckDB 1.3 Documentation / man.mtool.work