Results of 1 - 10 of about 370 for numeric (0.005 sec.)
- Literal Types – DuckDB 12872
- 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
...Prepared Statements Data Types Overview Array Bitstring 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 Comparison...tions Date Part Functions Enum Functions Interval Functions Lambda Functions List Functions Map Functions Nested Functions Numeric Functions Pattern Matching Regular Expressions Struct Functions Text Functions Time Functions Timestamp Functions Timestam...r example, the integer literal 42 can be implicitly converted to a TINYINT , but the integer literal 1000 cannot be. Other Numeric Literals Non-integer numeric literals can be denoted with decimal notation, using the period character ( . ) to separate t... - https://man.mtool.work/duckdb/1.3/sql/data_types/literal_types.html
- Numeric Functions – DuckDB 11920
- 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
...Prepared Statements Data Types Overview Array Bitstring 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 Comparison...tions Date Part Functions Enum Functions Interval Functions Lambda Functions List Functions Map Functions Nested Functions Numeric Functions Pattern Matching Regular Expressions Struct Functions Text Functions Time Functions Timestamp Functions Timestam...verview Storage Versions and Format Execution Format Pivot Sitemap Live Demo Documentation / SQL / Functions Copy Markdown Numeric Functions Numeric Operators The table below shows the available mathematical operators for numeric types . Operator Descri... - https://man.mtool.work/duckdb/1.3/sql/functions/numeric.html
- Date Part Functions – DuckDB 9700
- 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
...Prepared Statements Data Types Overview Array Bitstring 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 Comparison...tions Date Part Functions Enum Functions Interval Functions Lambda Functions List Functions Map Functions Nested Functions Numeric Functions Pattern Matching Regular Expressions Struct Functions Text Functions Time Functions Timestamp Functions Timestam...certain subfields: Name Description century(date) Century. day(date) Day. dayofmonth(date) Day (synonym). dayofweek(date) Numeric weekday (Sunday = 0, Saturday = 6). dayofyear(date) Day of the year (starts from 1, i.e., January 1 = 1). decade(date) Dec... - https://man.mtool.work/duckdb/1.3/sql/functions/datepart.html
- Numeric Types – DuckDB 9215
- 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
...Prepared Statements Data Types Overview Array Bitstring 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 Comparison...tions Date Part Functions Enum Functions Interval Functions Lambda Functions List Functions Map Functions Nested Functions Numeric Functions Pattern Matching Regular Expressions Struct Functions Text Functions Time Functions Timestamp Functions Timestam...erview Storage Versions and Format Execution Format Pivot Sitemap Live Demo Documentation / SQL / Data Types Copy Markdown Numeric Types Integer Types The types TINYINT , SMALLINT , INTEGER , BIGINT and HUGEINT store whole numbers, that is, numbers with... - https://man.mtool.work/duckdb/1.3/sql/data_types/numeric.html
- DuckDB_% Metadata Functions – DuckDB 8264
- 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
...Prepared Statements Data Types Overview Array Bitstring 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 Comparison...tions Date Part Functions Enum Functions Interval Functions Lambda Functions List Functions Map Functions Nested Functions Numeric Functions Pattern Matching Regular Expressions Struct Functions Text Functions Time Functions Timestamp Functions Timestam...length Always NULL . DuckDB text types do not enforce a value length restriction based on a length type parameter. INTEGER numeric_precision The number of units (in the base indicated by numeric_precision_radix ) used for storing column values. For inte... - https://man.mtool.work/duckdb/1.3/sql/meta/duckdb_table_functions.html
- Enum Functions – DuckDB 7629
- 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
...Prepared Statements Data Types Overview Array Bitstring 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 Comparison...tions Date Part Functions Enum Functions Interval Functions Lambda Functions List Functions Map Functions Nested Functions Numeric Functions Pattern Matching Regular Expressions Struct Functions Text Functions Time Functions Timestamp Functions Timestam...e result depends only on the type of the argument and not on its value. Name Description enum_code(enum_value) Returns the numeric value backing the given enum value. enum_first(enum) Returns the first value of the input enum type. enum_last(enum) Retur... - https://man.mtool.work/duckdb/1.3/sql/functions/enum.html
- Information Schema – DuckDB 6519
- 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
...Prepared Statements Data Types Overview Array Bitstring 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 Comparison...tions Date Part Functions Enum Functions Interval Functions Lambda Functions List Functions Map Functions Nested Functions Numeric Functions Pattern Matching Regular Expressions Struct Functions Text Functions Time Functions Timestamp Functions Timestam...m octet length depends on the declared character maximum length (see above) and the character encoding. INTEGER 1073741824 numeric_precision If data_type identifies a numeric type, this column contains the (declared or implicit) precision of the type fo... - https://man.mtool.work/duckdb/1.3/sql/meta/information_schema.html
- Expression API – DuckDB 6361
- 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
...Prepared Statements Data Types Overview Array Bitstring 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 Comparison...tions Date Part Functions Enum Functions Interval Functions Lambda Functions List Functions Map Functions Nested Functions Numeric Functions Pattern Matching Regular Expressions Struct Functions Text Functions Time Functions Timestamp Functions Timestam...n ( "case when a = 1 then 1 else 0 end" ). alias ( "selecting_case_expression" ), SQLExpression ( "1" ). alias ( "constant_numeric_column" ), SQLExpression ( "'hello'" ). alias ( "constant_text_column" ) ). aggregate ( aggr_expr = [ SQLExpression ( "SUM... - https://man.mtool.work/duckdb/1.3/clients/python/expression.html
- Loops – DuckDB 6361
- 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
...Prepared Statements Data Types Overview Array Bitstring 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 Comparison...tions Date Part Functions Enum Functions Interval Functions Lambda Functions List Functions Map Functions Nested Functions Numeric Functions Pattern Matching Regular Expressions Struct Functions Text Functions Time Functions Timestamp Functions Timestam...nt smallint integer bigint hugeint ⟨unsigned⟩ utinyint usmallint uinteger ubigint uhugeint ⟨integral⟩ ⟨signed⟩ ⟨unsigned⟩ ⟨numeric⟩ ⟨integral⟩ float double ⟨alltypes⟩ ⟨numeric⟩ bool interval varchar json Use large loops sparingly. Executing hundreds of... - https://man.mtool.work/duckdb/1.3/dev/sqllogictest/loops.html
- Data Types – DuckDB 6044
- 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
...Prepared Statements Data Types Overview Array Bitstring 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 Comparison...tions Date Part Functions Enum Functions Interval Functions Lambda Functions List Functions Map Functions Nested Functions Numeric Functions Pattern Matching Regular Expressions Struct Functions Text Functions Time Functions Timestamp Functions Timestam...ary data BOOLEAN BOOL , LOGICAL Logical Boolean ( true / false ) DATE Calendar date (year, month day) DECIMAL(prec, scale) NUMERIC(prec, scale) Fixed-precision number with the given width (precision) and scale, defaults to prec = 18 and scale = 3 DOUBLE... - https://man.mtool.work/duckdb/1.3/sql/data_types/overview.html
DuckDB 1.3 Documentation / man.mtool.work