Results of 1 - 10 of about 34 for numeric (0.002 sec.)
- Numeric Functions 12063
- Numeric Operators The table below shows the available mathematical operators for numeric types . Operator Description Example Result + Addition 2 + 3 5 - Subtraction 2 - 3 -1 * Multiplication 2 * 3 6 / Float division 5 / 2 2.5 // Division 5
...wise, bitwise negation, and factorial operators work only on integral data types, whereas the others are available for all numeric data types. Numeric Functions The table below shows the available mathematical functions. Name Description @(x) Absolute v...y . radians(x) Converts degrees to radians. random() Returns a random number x in the range 0.0 <= x < 1.0 . round_even(v NUMERIC, s INTEGER) Alias of roundbankers(v, s) . Round to s decimal places using the rounding half to even rule . Values s < 0 ar...e allowed. roundbankers(v NUMERIC, s INTEGER) Alias of round_even(v, s) . Round to s decimal places using the rounding half to even rule . Values s < 0 are... - https://man.mtool.work/duckdb/2.0/sql/functions/numeric.html
- Literal Types 11775
- DuckDB has special literal types for representing NULL , integer and string literals in queries. These have their own binding and conversion rules. Prior to DuckDB version 0.10.0, integer and string literals behaved identically to the INTEG
...ion with 0x or 0b prefixes respectively, can be cast to integer types, e.g., '0xFF'::INT = 255 or '0b101'::INT = 5 . Other Numeric Literals Non-integer numeric literals can be denoted with decimal notation, using the period character ( . ) to separate t...r the integer part or the decimal part may be omitted: SELECT 1.5; -- 1.5 SELECT .50; -- 0.5 SELECT 2.; -- 2.0 Non-integer numeric literals can also be denoted using E notation . In E notation, an integer or decimal literal is followed by an exponential...r of the exponent: SELECT 1e2; -- 100 SELECT 6.02214e23; -- Avogadro's constant SELECT 1e-10; -- 1 ångström Underscores in Numeric Literals DuckDB's SQL dialect allows using the underscore character _ in numeric literals as an optional separator. The ru... - https://man.mtool.work/duckdb/2.0/sql/data_types/literal_types.html
- Syntax Highlighting 10912
- Syntax highlighting in the CLI is available for macOS, Linux and Windows. SQL queries that are written in the shell are automatically highlighted using syntax highlighting. There are several components of a query that are highlighted in dif
...f command. Below is a list of query components that can be configured. Type Component Default color Keywords keyword green Numeric constants numeric_constant yellow String constants string_constant yellow Comments comment gray Errors error red Continuat...mple, here is an alternative set of syntax highlighting colors: .highlight_colors keyword brightred bold .highlight_colors numeric_constant white .highlight_colors string_constant white .highlight_colors comment cyan .highlight_colors error yellow .high... - https://man.mtool.work/duckdb/2.0/clients/cli/syntax_highlighting.html
- Date Part Functions 10912
- The date_part , date_trunc and date_diff functions can be used to extract or manipulate parts of temporal types such as TIMESTAMP , TIMESTAMPTZ , DATE and INTERVAL . The parts to be extracted or manipulated are specified by one of the strin
...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...ade (year / 10). epoch(date) Seconds since 1970-01-01. era(date) Calendar era. hour(date) Hours. isodow(date) Numeric ISO weekday (Monday = 1, Sunday = 7). isoyear(date) ISO Year number (Starts on Monday of week containing Jan 4th). julian(...ute(date) Time zone offset minutes portion. timezone(date) Time zone offset in seconds. week(date) ISO Week. weekday(date) Numeric weekday synonym (Sunday = 0, Saturday = 6). weekofyear(date) ISO Week (synonym). year(date) Year. yearweek(date) BIGINT of... - https://man.mtool.work/duckdb/2.0/sql/functions/datepart.html
- Numeric Types 10481
- Fixed-Width Integer Types The types TINYINT , SMALLINT , INTEGER , BIGINT and HUGEINT store whole numbers, that is, numbers without fractional components, of various ranges. Attempts to store values outside of the allowed range will result
...such number requires 8 megabytes. Fixed-Point Decimals The data type DECIMAL(WIDTH, SCALE) (also available under the alias NUMERIC(WIDTH, SCALE) ) represents an exact fixed-point decimal value. When creating a value of type DECIMAL , the WIDTH and SCALE...AS "DECIMAL(10,)"; DECIMAL DECIMAL() DECIMAL(10) DECIMAL(10,) DECIMAL(18,3) DECIMAL(18,3) DECIMAL(10,0) DECIMAL(10,0) The NUMERIC alias accepts the same spellings and yields the same types. Note that a bare DECIMAL is not an unconstrained decimal type...reason for why this is insufficient. Floating-Point Types The data types FLOAT and DOUBLE precision are variable-precision numeric types. In practice, these types are usually implementations of IEEE Standard 754 for Binary Floating-Point Arithmetic (sin... - https://man.mtool.work/duckdb/2.0/sql/data_types/numeric.html
- DuckDB_% Metadata Functions 9762
- DuckDB offers a collection of table functions that provide metadata about the current database. These functions reside in the main schema and their names are prefixed with duckdb_ . The resultset returned by a duckdb_ table function may be
...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...gral and approximate numeric types, this is the number of bits. For decimal types, this is the number of digit positions. INTEGER numeric_precision_rad...ix The number-base of the units in the numeric_precision column. For integral and approximate numeric types, this is 2 , indicating the precision is expressed as a numbe... - https://man.mtool.work/duckdb/2.0/sql/meta/duckdb_table_functions.html
- Information Schema 9043
- The views in the information_schema are SQL-standard views that describe the catalog entries of the database. These views can be filtered to obtain information about a specific column or table. DuckDB's implementation is based on PostgreSQL
...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...lumn. The precision indicates the number of significant digits. For all other data types, this column is NULL . INTEGER 18 numeric_scale If data_type identifies a numeric type, this column contains the (declared or implicit) scale of the type for this c... - https://man.mtool.work/duckdb/2.0/sql/meta/information_schema.html
- Enum Functions 8899
- This section describes functions and operators for examining and manipulating ENUM values . The examples assume an enum type created as: CREATE TYPE mood AS ENUM ('sad', 'ok', 'happy', 'anxious'); These functions can take NULL or a specific
...alue that depends on the argument value, as well as its type. Name Description enum_code(enum_value) Returns the (0-based) numeric value backing the given enum value. enum_first(enum) Returns the first value of the input enum type. enum_last(enum) Retur...turns the range between the two given enum values as an array. enum_code(enum_value) | Description | Returns the (0-based) numeric value backing the given enum value. | | Example | enum_code('happy'::mood) | | Result | 2 | enum_first(enum) | Description... - https://man.mtool.work/duckdb/2.0/sql/functions/enum.html
- PostgreSQL Extension 8755
- The postgres extension allows DuckDB to directly read and write data from a running PostgreSQL database instance. The data can be queried directly from the underlying PostgreSQL database. Data can be loaded from PostgreSQL tables into DuckD
...ections NULL pg_null_byte_replacement When writing NULL bytes to PostgreSQL, replace them with the given character NULL pg_numeric_as_varchar Read PostgreSQL NUMERIC values without precision and scale or with precision greater than 38 as VARCHAR instead...of DOUBLE false pg_numeric_nan_as_null Read PostgreSQL NUMERIC NaN values as NULL instead of throwing an error true pg_oauth_token OAuth bearer token... - https://man.mtool.work/duckdb/2.0/core_extensions/postgres/overview.html
- Loops 8755
- Loops can be used in sqllogictests when it is required to execute the same query many times but with slight modifications in constant values. For example, suppose we want to fire off 100 queries that check for the presence of the values 0..
...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/2.0/dev/sqllogictest/loops.html
DuckDB 2.0 Documentation / man.mtool.work