Results of 1 - 10 of about 43 for cast (0.005 sec.)
- Typecasting – DuckDB 14083
- 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
...Blob Boolean Date Enum Interval List Literal Types Map NULL Values Numeric Struct Text Time Timestamp Time Zones Union Typecasting Expressions Overview CASE Expression Casting Collations Comparisons IN Operator Logical Operators Star Expression Subqu...ew Storage Versions and Format Execution 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 ano...ther data type. Like other SQL engines, DuckDB supports both implicit and explicit typecasting. Explicit Casting Explicit typecasting is performed by using a CAST expression. For example, CAST(col AS VARCHAR) or co... - https://man.mtool.work/duckdb/1.3/sql/data_types/typecasting.html
- Casting – DuckDB 13142
- 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
...Blob Boolean Date Enum Interval List Literal Types Map NULL Values Numeric Struct Text Time Timestamp Time Zones Union Typecasting Expressions Overview CASE Expression Casting Collations Comparisons IN Operator Logical Operators Star Expression Subqu...rview Storage Versions and Format Execution 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 d...ata type. Casting can occur either implicitly or explicitly. The syntax described here performs an explicit cast. More information on cas... - https://man.mtool.work/duckdb/1.3/sql/expressions/cast.html
- Union Type – DuckDB 11353
- 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
...Blob Boolean Date Enum Interval List Literal Types Map NULL Values Numeric Struct Text Time Timestamp Time Zones Union Typecasting Expressions Overview CASE Expression Casting Collations Comparisons IN Operator Logical Operators Star Expression Subqu...and simply keep the “tag” as the first entry. UNION values can be created with the union_value(tag := expr) function or by casting from a member type . Example Create a table with a UNION column: CREATE TABLE tbl1 ( u UNION ( num INTEGER , str VARCHA...R )); INSERT INTO tbl1 VALUES ( 1 ), ( 'two' ), ( union_value ( str : = 'three' )); Any type can be implicitly cast to a UNION containing the type. Any UNION can also be implicitly cast to another UNION if the source UNION members are a s... - https://man.mtool.work/duckdb/1.3/sql/data_types/union.html
- Complete API – DuckDB 9162
- 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
...Blob Boolean Date Enum Interval List Literal Types Map NULL Values Numeric Struct Text Time Timestamp Time Zones Union Typecasting Expressions Overview CASE Expression Casting Collations Comparisons IN Operator Logical Operators Star Expression Subqu...a_chunk duckdb_stream_fetch_chunk ( duckdb_result result ); duckdb_data_chunk duckdb_fetch_chunk ( duckdb_result result ); Cast Functions duckdb_cast_function duckdb_create_cast_function (); void duckdb_cast_function_set_source_type ( duckdb_cast_fun...ction cast_function , duckdb_logical_type source_type ); void duckdb_cast_function_set_target_type ( duckdb_cast_function cast_functi... - https://man.mtool.work/duckdb/1.3/clients/c/api.html
- Excel Export – DuckDB 8607
- 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
...Blob Boolean Date Enum Interval List Literal Types Map NULL Values Numeric Struct Text Time Timestamp Time Zones Union Typecasting Expressions Overview CASE Expression Casting Collations Comparisons IN Operator Logical Operators Star Expression Subqu...f VARCHAR and DOUBLE , the following type conversions are automatically 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 o...hen styled with a "number format" so that they appear as dates or times when opened in Excel. TIMESTAMP_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 , wit... - https://man.mtool.work/duckdb/1.3/guides/file_formats/excel_export.html
- JSON Type – DuckDB 8453
- 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
...Blob Boolean Date Enum Interval List Literal Types Map NULL Values Numeric Struct Text Time Timestamp Time Zones Union Typecasting Expressions Overview CASE Expression Casting Collations Comparisons IN Operator Logical Operators Star Expression Subqu...he bottom of this page). All JSON creation functions return values of this type. We also allow any of DuckDB's types to be cast to JSON, and JSON to be cast back to any of DuckDB's types, for example, to cast JSON to DuckDB's STRUCT type, run: SELECT...t also for non-nested types: SELECT '2023-05-12' :: DATE :: JSON ; "2023-05-12" The only exception to this behavior is the cast from VARCHAR to JSON , which does not alter the data, but instead parses and validates the contents of the VARCHAR as JSON... - https://man.mtool.work/duckdb/1.3/data/json/json_type.html
- Swift Client – DuckDB 8407
- This page is for DuckDB 1.3, which is outdated. Switch to the current documentation . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Ove
...Blob Boolean Date Enum Interval List Literal Types Map NULL Values Numeric Struct Text Time Timestamp Time Zones Union Typecasting Expressions Overview CASE Expression Casting Collations Comparisons IN Operator Logical Operators Star Expression Subqu...B from within Swift via an async function. This means the callee won't be blocked while the query is executing. We'll then cast the result columns to Swift native types using DuckDB's ResultSet cast(to:) family of methods, before finally wrapping the...n . query ( """ SELECT disc_year, count(disc_year) AS Count FROM exoplanets GROUP BY disc_year ORDER BY disc_year """ ) // Cast our DuckDB columns to their native Swift // equivalent types let discoveryYearColumn = result [ 0 ] . cast ( to : Int . se... - https://man.mtool.work/duckdb/1.3/clients/swift.html
- Enum Data Type – DuckDB 8252
- 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
...Blob Boolean Date Enum Interval List Literal Types Map NULL Values Numeric Struct Text Time Timestamp Time Zones Union Typecasting Expressions Overview CASE Expression Casting Collations Comparisons IN Operator Logical Operators Star Expression Subqu...ngle column of VARCHAR s: CREATE TYPE enum_name AS ENUM ( select_expression ); Enums can also be created on the fly during casting : SELECT 'some_string' :: ENUM ( value_1 , value_2 , ...); Examples Creates new user defined type mood as an enum: CREA...mood type does not have quackity-quack value. INSERT INTO person VALUES ( 'Hannes' , 'quackity-quack' ); The string sad is cast to the type mood , returning a numerical reference value. This makes the comparison a numerical comparison instead of a st... - https://man.mtool.work/duckdb/1.3/sql/data_types/enum.html
- Utility Functions – DuckDB 7805
- 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
...Blob Boolean Date Enum Interval List Literal Types Map NULL Values Numeric Struct Text Time Timestamp Time Zones Union Typecasting Expressions Overview CASE Expression Casting Collations Comparisons IN Operator Logical Operators Star Expression Subqu...ize into specific function types and are broadly useful. Name Description alias(column) Return the name of the column. can_cast_implicitly(source_value, target_value) Whether or not we can implicitly cast from the types of the source value to the tar...DuckDB in this format. alias(column) Description Return the name of the column. Example alias(column1) Result column1 can_cast_implicitly(source_value, target_value) Description Whether or not we can implicitly cast from the types of the source valu... - https://man.mtool.work/duckdb/1.3/sql/functions/utility.html
- Reading Faulty CSV Files – DuckDB 7759
- 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
...Blob Boolean Date Enum Interval List Literal Types Map NULL Values Numeric Struct Text Time Timestamp Time Zones Union Typecasting Expressions Overview CASE Expression Casting Collations Comparisons IN Operator Logical Operators Star Expression Subqu...der the following table: CREATE TABLE people ( name VARCHAR , birth_date DATE ); DuckDB detects the following error types: CAST : Casting errors occur when a column in the CSV file cannot be cast to the expected schema value. For example, the line Pe...dro,The 90s would cause an error since the string The 90s cannot be cast to a date. MISSING COLUMNS : This error occurs if a line in the CSV file has fewer columns than expected. In our example,... - https://man.mtool.work/duckdb/1.3/data/csv/reading_faulty_csv_files.html
DuckDB 1.3 Documentation / man.mtool.work