Results of 1 - 10 of about 34 for convert (0.003 sec.)
- Conversion between DuckDB and Python – DuckDB 15050
- 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
...Documentation / Client APIs / Python Copy Markdown Conversion between DuckDB and Python This page documents the rules for converting Python objects to DuckDB and DuckDB results to Python . Object Conversion: Python Object to DuckDB This is a mapping of...if it's available and return NULL if it returns true . We check against datetime.datetime.min and datetime.datetime.max to convert to -inf and +inf respectively. If the datetime has tzinfo, we will use TIMESTAMPTZ , otherwise it becomes TIMESTAMP . date...time.time If the time has tzinfo, we will use TIMETZ , otherwise it becomes TIME . datetime.date date converts to the DATE type. We check against datetime.date.min and datetime.date.max to convert to -inf and +inf respectively. byte... - https://man.mtool.work/duckdb/1.3/clients/python/conversion.html
- Executing SQL in Python – DuckDB 10161
- 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
...tion. import duckdb duckdb . sql ( "SELECT 42" ). show () By default this will create a relation object. The result can be converted to various formats using the result conversion functions. For example, the fetchall method can be used to convert the re...( "SELECT 42" ). fetchall () print ( results ) [(42,)] Several other result objects exist. For example, you can use df to convert the result to a Pandas DataFrame. results = duckdb . sql ( "SELECT 42" ). df () print ( results ) 42 0 42 By default, a gl...FROM integers" ). show () 関連キーワード duckdb using results integers queries executed show default example fetchall used convert objects print connection connect Documentation Guides Copy Markdown Executing import create relation converted 関連するペー... - https://man.mtool.work/duckdb/1.3/guides/python/execute_sql.html
- TRY expression – DuckDB 10161
- 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
...apped into as TRY expression, they return NULL : Casting Without TRY SELECT 'abc' :: INTEGER ; Conversion Error: Could not convert string 'abc' to INT32 With TRY SELECT TRY ( 'abc' :: INTEGER ); NULL Logarithm on Zero Without TRY SELECT ln ( 0 ); Out of...( FROM ( VALUES ( '123' ), ( 'test' ), ( '235' )) t ( a )) SELECT a :: INTEGER AS x FROM cte ; Conversion Error: Could not convert string 'test' to INT32 With TRY WITH cte AS ( FROM ( VALUES ( '123' ), ( 'test' ), ( '235' )) t ( a )) SELECT TRY ( a :: I...n combination with a volatile function 関連キーワード expression Without errors rows scalar return they Casting Conversion convert cannot used combination volatile Documentation Expressions Copy Markdown ensures caused input child those instead causing... - https://man.mtool.work/duckdb/1.3/sql/expressions/try.html
- ALTER TABLE Statement – DuckDB 9969
- 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
...LE integers ALTER i TYPE VARCHAR ; Change the type of the column i to the type VARCHAR , using the specified expression to convert the data for each row: ALTER TABLE integers ALTER i SET DATA TYPE VARCHAR USING concat ( i , '_' , j ); Set the default va...n_name SET DATA TYPE type clauses. Change the type of the column i to the type VARCHAR , using the specified expression to convert the data for each row: ALTER TABLE integers ALTER i SET DATA TYPE VARCHAR USING concat ( i , '_' , j ); The [SET [DATA]] T...YPE clause changes the type of a column in a table. Any data present in the column is converted according to the provided expression in the USING clause, or, if the USING clause is absent, cast to the new data type.... - https://man.mtool.work/duckdb/1.3/sql/statements/alter_table.html
- Editing – DuckDB 9602
- 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
...g after the cursor Ctrl + T Swap current and next character Ctrl + U Delete all text Ctrl + W Delete previous word Alt + C Convert next word to titlecase Alt + D Delete next word Alt + L Convert next word to lowercase Alt + R Delete all text Alt + T Swa...p current and next word Alt + U Convert next word to uppercase Alt + Backspace Delete previous word Alt + \ Delete spaces around cursor Completing Key Action Tab... - https://man.mtool.work/duckdb/1.3/clients/cli/editing.html
- Casting – DuckDB 9602
- 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 Pivot Sitemap Live Demo Documentation / SQL / Expressions Copy Markdown Casting Casting refers to the operation of converting a value in a particular data type to the corresponding value in another data type. Casting can occur either implicitly...ate_series ( 1 , 3 ) tbl ( i ); i 1.0 2.0 3.0 Casting Rules Not all casts are possible. For example, it is not possible to convert an INTEGER to a DATE . Casts may also throw errors when the cast could not be successfully performed. For example, trying...hello' to an INTEGER will result in an error being thrown. SELECT CAST ( 'hello' AS INTEGER ); Conversion Error: Could not convert string 'hello' to INT32 The exact behavior of the cast depends on the source and destination types. For example, when cast... - https://man.mtool.work/duckdb/1.3/sql/expressions/cast.html
- Typecasting – DuckDB 9027
- 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 Pivot Sitemap Live Demo Documentation / SQL / Data Types Copy Markdown Typecasting Typecasting is an operation that converts a value in one particular data type to the closest corresponding value in another data type. Like other SQL engines, Duck...kes as input argument a column of type DOUBLE , however, it can be called with an integer as well: sin(1) . The integer is converted into a double before being passed to the sin function. Tip To check whether a type can be implicitly cast to another typ...a type cannot always be cast to any arbitrary target data type. The only exception is the NULL value – which can always be converted between types. The following matrix describes which conversions are supported. When implicit casting is allowed, it impl... - https://man.mtool.work/duckdb/1.3/sql/data_types/typecasting.html
- query and query_table Functions – DuckDB 8659
- 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
...SQL Features Copy Markdown query and query_table Functions The query and query_table functions take a string literal, and convert it into a SELECT subquery and a table reference, respectively. Note that these functions only accept literal strings. As s...mn unnest alias literal they powerful generic example summarize Documentation Guides Features Copy Markdown Functions take convert subquery reference respectively Note these 関連するページ Summarize DESCRIBE Statement CALL Statement SELECT Clause SUMMAR... - https://man.mtool.work/duckdb/1.3/guides/sql_features/query_and_query_table_func...
- Full-Text Search Extension – DuckDB 8084
- 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
...])+' , ignoring all escaped and non-alphabetic lowercase characters strip_accents BOOLEAN Whether to remove accents (e.g., convert á to a ). Defaults to 1 lower BOOLEAN Whether to convert all text to lowercase. Defaults to 1 overwrite BOOLEAN Whether to... - https://man.mtool.work/duckdb/1.3/core_extensions/full_text_search.html
- Storage Versions and Format – DuckDB 8084
- 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
...that you will be able to read the files without having to worry about which version the file was written with or having to convert files between versions. Forward Compatibility Forward compatibility refers to the ability of an older DuckDB version to re...is means that file2 can be opened by past DuckDB versions while file1 is compatible only with v1.2.0 (or future versions). Converting between Storage Versions To convert from the new format to the old format for compatibility, use the following sequence...in DuckDB v1.2.0+: ATTACH 'file1.db' ; ATTACH 'converted_file.db' ( STORAGE_VERSION 'v1.0.0' ); COPY FROM DATABASE file1 TO converted_file ; Storage Header DuckDB files start wi... - https://man.mtool.work/duckdb/1.3/internals/storage.html
DuckDB 1.3 Documentation / man.mtool.work