Results of 1 - 10 of about 23 for until (0.005 sec.)
- Timestamp Functions – DuckDB 11813
- 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
...format string . strptime(text, format-list) Converts the string text to timestamp applying the format strings in the list until one succeeds. Throws an error on failure. To return NULL on failure, use try_strptime . strptime(text, format) Converts th...is a Monday. try_strptime(text, format-list) Converts the string text to timestamp applying the format strings in the list until one succeeds. Returns NULL on failure. try_strptime(text, format) Converts the string text to timestamp according to the f...0 PM strptime(text, format-list) Description Converts the string text to timestamp applying the format strings in the list until one succeeds. Throws an error on failure. To return NULL on failure, use try_strptime . Example strptime('4/15/2023 10:56:... - https://man.mtool.work/duckdb/1.3/sql/functions/timestamp.html
- ALTER VIEW Statement – DuckDB 11813
- 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
...changes made by ALTER VIEW fully respect the transactional semantics, i.e., they will not be visible to other transactions until committed, and can be fully reverted through a rollback. Note that other views that rely on the table are not automaticall...s Copy Markdown Statement statement catalog Examples Rename made respect transactional semantics they visible transactions until committed reverted 関連するページ CREATE VIEW Statement Transaction Management CREATE SCHEMA Statement ALTER TABLE Stateme... - https://man.mtool.work/duckdb/1.3/sql/statements/alter_view.html
- Text Functions – DuckDB 11394
- 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
...lower(string) Converts string to lower case. lpad(string, count, character) Pads the string with the character on the left until it has count characters. Truncates the string on the right if it has more than count characters. ltrim(string[, characters...h_slash (default), forward_slash , backslash . parse_dirpath(path[, separator]) Returns the head of the path (the pathname until the last slash) similarly to Python's os.path.dirname . separator options: system , both_slash (default), forward_slash ,...cts the right-most count grapheme clusters. rpad(string, count, character) Pads the string with the character on the right until it has count characters. Truncates the string on the right if it has more than count characters. rtrim(string[, characters... - https://man.mtool.work/duckdb/1.3/sql/functions/text.html
- Vectors – DuckDB 10573
- 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
...res ; duckdb_query ( con , "SELECT CASE WHEN i%2=0 THEN NULL ELSE i END res_col FROM range(10) t(i)" , & res ); // iterate until result is exhausted while ( true ) { duckdb_data_chunk result = duckdb_fetch_chunk ( res ); if ( ! result ) { // result is...CASE WHEN i%2=0 THEN CONCAT('short_', i) ELSE CONCAT('longstringprefix', i) END FROM range(10) t(i)" , & res ); // iterate until result is exhausted while ( true ) { duckdb_data_chunk result = duckdb_fetch_chunk ( res ); if ( ! result ) { // result is...L ELSE {'col1': i, 'col2': CASE WHEN i%2=0 THEN NULL ELSE 100 + i * 42 END} END FROM range(10) t(i)" , & res ); // iterate until result is exhausted while ( true ) { duckdb_data_chunk result = duckdb_fetch_chunk ( res ); if ( ! result ) { // result is... - https://man.mtool.work/duckdb/1.3/clients/c/vector.html
- Excel Import – DuckDB 10171
- 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
...B will stop reading the Excel file at when encountering an empty row. But when a range is provided, the default is to read until the end of the range. This behavior can be controlled with the stop_at_empty parameter: -- Read the first 100 rows, or unt... - https://man.mtool.work/duckdb/1.3/guides/file_formats/excel_import.html
- C++ API – DuckDB 9333
- 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
...TR is the return type of the UDF function; Args are the arguments up to 3 for the UDF function (this method only supports until ternary functions); name : is the name to register the UDF function; udf_func : is a pointer to the UDF function. This met...TR is the return type of the UDF function; Args are the arguments up to 3 for the UDF function (this method only supports until ternary functions); name : is the name to register the UDF function; args : are the LogicalType arguments that the functio... - https://man.mtool.work/duckdb/1.3/clients/cpp.html
- Conversion between DuckDB and Python – DuckDB 9333
- 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
...arbitrary size in Python, there is not a one-to-one conversion possible for ints. Instead we perform these casts in order until one succeeds: BIGINT INTEGER UBIGINT UINTEGER DOUBLE When using the DuckDB Value class, it's possible to set a target type..., which will influence the conversion. float These casts are tried in order until one succeeds: DOUBLE FLOAT datetime.datetime For datetime we will check pandas.isnull if it's available and return NULL if... - https://man.mtool.work/duckdb/1.3/clients/python/conversion.html
- Parquet Encryption – DuckDB 8093
- 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 Parquet encryption currently has the following limitations. It is not compatible with the encryption of, e.g., PyArrow, until the missing details are implemented. DuckDB encrypts the footer and all columns using the footer_key . The Parquet specifi... - https://man.mtool.work/duckdb/1.3/data/parquet/encryption.html
- Multiple Connections – DuckDB 8093
- 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
...tart a transaction and create a table in con1 , then fire a query in con2 that checks that the table is not accessible yet until committed. We can use multiple connections in the sqllogictests using connection labels . The connection label can be opti... - https://man.mtool.work/duckdb/1.3/dev/sqllogictest/multiple_connections.html
- Functions – DuckDB 8093
- 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
...sent. The first (leftmost) bit is indexed 1 bitstring scalar BIT [bitstring, length] [VARCHAR, INTEGER] Pads the bitstring until the specified length Currently, the description and parameter names of functions are not available in the duckdb_functions... - https://man.mtool.work/duckdb/1.3/sql/functions/overview.html
DuckDB 1.3 Documentation / man.mtool.work