Results of 1 - 10 of about 32 for converted (0.006 sec.)
- Values – DuckDB 13951
- 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
..._value val ); Parameters val : A duckdb_value containing a boolean Return Value A boolean, or false if the value cannot be converted duckdb_get_int8 Returns the int8_t value of the given value. Syntax int8_t duckdb_get_int8 ( duckdb_value val ); Parameter...s val : A duckdb_value containing a tinyint Return Value A int8_t, or MinValue if the value cannot be converted duckdb_get_uint8 Returns the uint8_t value of the given value. Syntax uint8_t duckdb_get_uint8 ( duckdb_value val ); Param...eters val : A duckdb_value containing a utinyint Return Value A uint8_t, or MinValue if the value cannot be converted duckdb_get_int16 Returns the int16_t value of the given value. Syntax int16_t duckdb_get_int16 ( duckdb_value val ); Param... - https://man.mtool.work/duckdb/1.3/clients/c/value.html
- Complete API – DuckDB 13661
- 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
...for removal in a future release. Return Value The boolean value at the specified location, or false if the value cannot be converted. Syntax bool duckdb_value_boolean ( duckdb_result * result , idx_t col , idx_t row ); duckdb_value_int8 Warning Deprecatio...uled for removal in a future release. Return Value The int8_t value at the specified location, or 0 if the value cannot be converted. Syntax int8_t duckdb_value_int8 ( duckdb_result * result , idx_t col , idx_t row ); duckdb_value_int16 Warning Deprecatio...led for removal in a future release. Return Value The int16_t value at the specified location, or 0 if the value cannot be converted. Syntax int16_t duckdb_value_int16 ( duckdb_result * result , idx_t col , idx_t row ); duckdb_value_int32 Warning Deprecat... - https://man.mtool.work/duckdb/1.3/clients/c/api.html
- Literal Types – DuckDB 9327
- 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
...ER and VARCHAR types. Null Literals The NULL literal is denoted with the keyword NULL . The NULL literal can be implicitly converted to any other type. Integer Literals Integer literals are denoted as a sequence of one or more digits. At runtime, these re...sult in values of the INTEGER_LITERAL type. INTEGER_LITERAL types can be implicitly converted to any integer type in which the value fits. For example, the integer literal 42 can be implicitly converted to a TINYINT...and does not work with other kinds of string values. Implicit String Conversion STRING_LITERAL instances can be implicitly converted to any other type. For example, we can compare string literals with dates: SELECT d > '1992-01-01' AS result FROM ( VALUES... - https://man.mtool.work/duckdb/1.3/sql/data_types/literal_types.html
- Timestamp Types – DuckDB 8940
- 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
...ns with nanosecond precision and WITH TIME ZONE semantics, e.g., Parquet timestamp columns with isAdjustedToUTC=true , are converted to TIMESTAMP WITH TIME ZONE and thus lose precision when read using DuckDB. SELECT TIMESTAMP_NS '1992-09-20 11:30:00.12345...biguous, but requires the ICU extension to handle time zone names. When strings without UTC offsets or time zone names are converted to a WITH TIME ZONE type, the string is interpreted in the configured time zone. Conversely, when strings with UTC offsets...d time zone at the instant specified by the string is stored. Finally, when WITH TIME ZONE and WITHOUT TIME ZONE types are converted to each other via explicit or implicit casts, the translation uses the configured time zone. To use an alternative time zo... - https://man.mtool.work/duckdb/1.3/sql/data_types/timestamp.html
- Creating JSON – DuckDB 8650
- 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
...ing functions are used to create JSON. Function Description to_json(any) Create JSON from a value of any type. Our LIST is converted to a JSON array, and our STRUCT and MAP are converted to a JSON object. json_quote(any) Alias for to_json . array_to_json(...erge_patch ( '{"duck": 42}' , '{"goose": 123}' ); {"goose":123,"duck":42} 関連キーワード json duck goose Create Alias list converted accepts argument merge patch Documentation Import Files Copy Markdown Creating Creation Functions following functions used... - https://man.mtool.work/duckdb/1.3/data/json/creating_json.html
- Typecasting – DuckDB 8650
- 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
...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 type,...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 implie...R ); In general, casting to VARCHAR is a lossless operation and any type can be cast back to the original type after being converted into text. SELECT CAST ( CAST ([ 1 , 2 , 3 ] AS VARCHAR ) AS INTEGER []); Literal Types Integer literals (such as 42 ) and... - https://man.mtool.work/duckdb/1.3/sql/data_types/typecasting.html
- Excel Export – DuckDB 8538
- 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
...y applied when writing XLSX files: Numeric types are cast to DOUBLE . Temporal types ( TIMESTAMP , DATE , TIME , etc.) are converted to Excel "serial" numbers, that is the number of days since 1900-01-01 for dates and the fraction of a day for times. Thes...MP_TZ and TIME_TZ are cast to UTC TIMESTAMP and TIME respectively, with the timezone information being lost. BOOLEAN s are converted to 1 and 0 , with a "number format" applied to make them appear as TRUE and FALSE in Excel. All other types are cast to VA...ワード Excel xlsx output files excel cast extension option also types number DuckDB supports exporting numbers type applied converted dates times format appear them Documentation Guides 関連するページ Excel Extension Excel Import Casting CSV Export JSON Ty... - https://man.mtool.work/duckdb/1.3/guides/file_formats/excel_export.html
- Excel Extension – DuckDB 8151
- 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
...of the resulting columns are determined by the types of the columns in the table being copied to. All cells will simply be converted by casting from DOUBLE or VARCHAR to the target column type. Writing XLSX Files Writing .xlsx files is supported using the...files. Numeric types are cast to DOUBLE when writing to an XLSX file. Temporal types ( TIMESTAMP , DATE , TIME , etc.) are converted to excel "serial" numbers, that is the number of days since 1900-01-01 for dates and the fraction of a day for times. Thes...MP_TZ and TIME_TZ are cast to UTC TIMESTAMP and TIME respectively, with the timezone information being lost. BOOLEAN s are converted to 1 and 0 , with a "number format" applied to make them appear as TRUE and FALSE in Excel. All other types are cast to VA... - https://man.mtool.work/duckdb/1.3/core_extensions/excel.html
- Export to Pandas – DuckDB 8151
- 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 / Guides / Python Copy Markdown Export to Pandas The result of a query can be converted to a Pandas DataFrame using the df() function. import duckdb # read the result of an arbitrary SQL query to a Pandas DataF...rts importing from Pandas . 関連キーワード Pandas query DataFrame duckdb results Documentation Guides Copy Markdown Export converted using import read arbitrary Also DuckDB also supports importing 関連するページ SQL on Pandas Import from Pandas Relational... - https://man.mtool.work/duckdb/1.3/guides/python/export_pandas.html
- Executing SQL in Python – DuckDB 8054
- 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 resu...fetchall used convert objects print connection connect Documentation Guides Copy Markdown Executing import create relation converted 関連するページ Python DB API Python API Export to Pandas Export to Apache Arrow CASE Expression Python Function API See th... - https://man.mtool.work/duckdb/1.3/guides/python/execute_sql.html
DuckDB 1.3 Documentation / man.mtool.work