Results of 1 - 10 of about 12 for casts (0.003 sec.)
- Typecasting – DuckDB 13301
- 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
...e column col to VARCHAR . See the cast page for more information. Implicit Casting In many situations, the system will add casts by itself. This is called implicit casting and happens, for example, when a function is called with an argument that does...not match the type of the function but can be cast to the required type. Implicit casts can only be added for a number of type combinations, and is generally only possible when the cast cannot fail. For example...g When values of different types need to be combined to an unspecified joint parent type, the system will perform implicit casts to an automatically selected parent type. For example, list_value(1::INT64, 1::UINT64) creates a list of type INT128[] . T... - https://man.mtool.work/duckdb/1.3/sql/data_types/typecasting.html
- Union Type – DuckDB 11638
- 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
...ee Select the currently active tag from the UNION as an ENUM . SELECT union_tag ( u ) AS t FROM tbl1 ; t num str str Union Casts Compared to other nested types, UNION s allow a set of implicit casts to facilitate unintrusive and natural usage when wor...king with their members as “subtypes”. However, these casts have been designed with two principles in mind, to avoid ambiguity and to avoid casts that could lead to loss of informati...exception to this is when casting a UNION to VARCHAR , in which case the members will all use their corresponding VARCHAR casts. Since everything can be cast to VARCHAR , this is “safe” in a sense. Casting to Unions A type can always be implicitly ca... - https://man.mtool.work/duckdb/1.3/sql/data_types/union.html
- Comparisons – DuckDB 9392
- 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
...M NULL true Combination Casting When performing comparison on different types, DuckDB performs Combination Casting . These casts were introduced to make interactive querying more convenient and are in line with the casts performed by several programmi...son below type table Description These DuckDB equivalent shows Operator Example less greater including Combination Casting casts PostgreSQL stricter checking otherwise 関連するページ Caveats TRY expression Expressions Logical Operators Relational API... - https://man.mtool.work/duckdb/1.3/sql/expressions/comparison_operators.html
- Timestamp Issues – 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
...Sitemap Live Demo Documentation / Guides / SQL Features Copy Markdown Timestamp Issues Timestamp with Time Zone Promotion Casts Working with time zones in SQL can be quite confusing at times. For example, when filtering to a date range, one might try...row table against any timestamp column to quickly obtain the temporal bin values for the time zone in question. The inner casts are not required, but result in a smaller table because date_part returns 64 bit integers for all parts. Notice that we ca...Foundation, Amsterdam NL DuckDB Home Code of Conduct Trademark Use Blog In this article Timestamp with Time Zone Promotion Casts Time Zone Performance Half Open Intervals... - https://man.mtool.work/duckdb/1.3/guides/sql_features/timestamps.html
- Casting – DuckDB 8560
- 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
...) tbl ( i ); i 1 2 3 SELECT i :: DOUBLE AS i FROM generate_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... - https://man.mtool.work/duckdb/1.3/sql/expressions/cast.html
- Conversion between DuckDB and Python – DuckDB 8207
- 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
...egers can be of 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 se...t 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 ava... - https://man.mtool.work/duckdb/1.3/clients/python/conversion.html
- Set Operations – DuckDB 7747
- 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
...and require the to-be-combined queries to have the same number of input columns. If the columns are not of the same type, casts may be added. The result will use the column names from the first query. DuckDB also supports UNION [ALL] BY NAME , which... - https://man.mtool.work/duckdb/1.3/sql/query_syntax/setops.html
- Numeric Types – DuckDB 7623
- 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
...OUBLE FLOAT8 Double precision floating-point number (8 bytes) Like for fixed-point data types, conversion from literals or casts from other datatypes to floating-point types stores inputs that cannot be represented exactly as approximations. However,... - https://man.mtool.work/duckdb/1.3/sql/data_types/numeric.html
- Timestamp Types – DuckDB 7623
- 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 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 zone, the timezone function provided by the ICU... - https://man.mtool.work/duckdb/1.3/sql/data_types/timestamp.html
- CREATE MACRO Statement – DuckDB 7623
- 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
...te function for the function call "add(STRING_LITERAL, INTEGER_LITERAL)". In order to select one, please add explicit type casts. Candidate functions: add(DATE, INTEGER) -> DATE add(INTEGER, INTEGER) -> INTEGER Macros can have default parameters. Unli... - https://man.mtool.work/duckdb/1.3/sql/statements/create_macro.html
DuckDB 1.3 Documentation / man.mtool.work