Results of 1 - 10 of about 31 for decimal (0.005 sec.)
- Date Format Functions – DuckDB 12764
- 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
...th name. January, February, … %c ISO date and time representation 1992-03-02 10:30:20 %d Day of the month as a zero-padded decimal. 01, 02, …, 31 %-d Day of the month as a decimal number. 1, 2, …, 30 %f Microsecond as a decimal number, zero-padded on th...e left. 000000 - 999999 %g Millisecond as a decimal number, zero-padded on the left. 000 - 999 %G ISO 8601 year with century representing the year that contains the greater p...art of the ISO week (see %V ). 0001, 0002, …, 2013, 2014, …, 9998, 9999 %H Hour (24-hour clock) as a zero-padded decimal number. 00, 01, …, 23 %-H Hour (24-hour clock) as a decimal number. 0, 1, …, 23 %I Hour (12-hour clock) as a zero-padded d... - https://man.mtool.work/duckdb/1.3/sql/functions/dateformat.html
- Types – DuckDB 12666
- 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
...ost primitive types, e.g., integers or varchars, the enum is sufficient. For more complex types, such as lists, structs or decimals, the logical type must be used. typedef enum DUCKDB_TYPE { DUCKDB_TYPE_INVALID = 0 , DUCKDB_TYPE_BOOLEAN = 1 , DUCKDB_TYP...15 , DUCKDB_TYPE_HUGEINT = 16 , DUCKDB_TYPE_UHUGEINT = 32 , DUCKDB_TYPE_VARCHAR = 17 , DUCKDB_TYPE_BLOB = 18 , DUCKDB_TYPE_DECIMAL = 19 , DUCKDB_TYPE_TIMESTAMP_S = 20 , DUCKDB_TYPE_TIMESTAMP_MS = 21 , DUCKDB_TYPE_TIMESTAMP_NS = 22 , DUCKDB_TYPE_ENUM = 2...lue functions do not support structural reading of composite types (lists or structs) or more complex types like enums and decimals. For more information about data chunks, see the documentation on data chunks . API Reference Overview duckdb_data_chunk... - https://man.mtool.work/duckdb/1.3/clients/c/types.html
- Numeric Types – DuckDB 11486
- 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
...ounded up to 16, becomes two extra bytes). Both negative and positive values are supported by the VARINT type. Fixed-Point Decimals The data type DECIMAL(WIDTH, SCALE) (also available under the alias NUMERIC(WIDTH, SCALE) ) represents an exact fixed-poi...nt decimal value. When creating a value of type DECIMAL , the WIDTH and SCALE can be specified to define which size of decimal values...the field. The WIDTH field determines how many digits can be held, and the scale determines the amount of digits after the decimal point. For example, the type DECIMAL(3, 2) can fit the value 1.23 , but cannot fit the value 12.3 or the value 1.234 . The... - https://man.mtool.work/duckdb/1.3/sql/data_types/numeric.html
- Complete API – DuckDB 11210
- 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
...idx_t col , idx_t row ); duckdb_uhugeint duckdb_value_uhugeint ( duckdb_result * result , idx_t col , idx_t row ); duckdb_decimal duckdb_value_decimal ( duckdb_result * result , idx_t col , idx_t row ); uint8_t duckdb_value_uint8 ( duckdb_result * resu...elpers double duckdb_uhugeint_to_double ( duckdb_uhugeint val ); duckdb_uhugeint duckdb_double_to_uhugeint ( double val ); Decimal Helpers duckdb_decimal duckdb_double_to_decimal ( double val , uint8_t width , uint8_t scale ); double duckdb_decimal_to_d...ouble ( duckdb_decimal val ); Prepared Statements duckdb_state duckdb_prepare ( duckdb_connection connection , const char * query , duckdb_prepar... - https://man.mtool.work/duckdb/1.3/clients/c/api.html
- Values – DuckDB 9285
- 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
..._uhugeint ( duckdb_uhugeint input ); duckdb_value duckdb_create_varint ( duckdb_varint input ); duckdb_value duckdb_create_decimal ( duckdb_decimal input ); duckdb_value duckdb_create_float ( float input ); duckdb_value duckdb_create_double ( double inp...); duckdb_uhugeint duckdb_get_uhugeint ( duckdb_value val ); duckdb_varint duckdb_get_varint ( duckdb_value val ); duckdb_decimal duckdb_get_decimal ( duckdb_value val ); float duckdb_get_float ( duckdb_value val ); double duckdb_get_double ( duckdb_va...s input : The duckdb_varint value Return Value The value. This must be destroyed with duckdb_destroy_value . duckdb_create_decimal Creates a DECIMAL value from a duckdb_decimal Syntax duckdb_value duckdb_create_decimal ( duckdb_decimal input ); Paramete... - https://man.mtool.work/duckdb/1.3/clients/c/value.html
- Literal Types – DuckDB 8654
- 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
...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 the integer part and the decimal part of the number. Either the int...eger 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 d...enoted using E notation . In E notation, an integer or decimal literal is followed by and exponential part, which is denoted by e or E , followed by a literal integer indicating the exp... - https://man.mtool.work/duckdb/1.3/sql/data_types/literal_types.html
- Vectors – DuckDB 8185
- 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
...; The length can either be accessed directly, or the duckdb_string_is_inlined can be used to check if a string is inlined. Decimals Decimals are stored as integer values internally. The exact native type depends on the width of the decimal type, as show...n in the following table: Width NativeType <= 4 int16_t <= 9 int32_t <= 18 int64_t <= 38 duckdb_hugeint The duckdb_decimal_internal_type can be used to obtain the internal type of the decimal. Decimals are stored as integer values multiplied by...10^scale . The scale of a decimal can be obtained using duckdb_decimal_scale . For example, a decimal value of 10.5 with type DECIMAL(8, 3) is stored intern... - https://man.mtool.work/duckdb/1.3/clients/c/vector.html
- Python DB API – DuckDB 8056
- 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
...the transaction. Below are some short examples: # create a table con . execute ( "CREATE TABLE items (item VARCHAR, value DECIMAL(10, 2), count INTEGER)" ) # insert two items into the table con . execute ( "INSERT INTO items VALUES ('jeans', 20.0, 1),...r', 42.2, 2)" ) # retrieve the items again con . execute ( "SELECT * FROM items" ) print ( con . fetchall ()) # [('jeans', Decimal('20.00'), 1), ('hammer', Decimal('42.20'), 2)] # retrieve the items one at a time con . execute ( "SELECT * FROM items" )...print ( con . fetchone ()) # ('jeans', Decimal('20.00'), 1) print ( con . fetchone ()) # ('hammer', Decimal('42.20'), 2) print ( con . fetchone ()) # This closes the tra... - https://man.mtool.work/duckdb/1.3/clients/python/dbapi.html
- Summarize – DuckDB 8007
- 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
...2501 4999 7500 6001215 0.0% l_linenumber INTEGER 1 7 7 3.0005757167506912 1.7324314036519328 2 3 4 6001215 0.0% l_quantity DECIMAL(15,2) 1.00 50.00 50 25.507967136654827 14.426262537016918 13 26 38 6001215 0.0% l_extendedprice DECIMAL(15,2) 901.00 10494...9.50 923139 38255.138484656854 23300.43871096221 18756 36724 55159 6001215 0.0% l_discount DECIMAL(15,2) 0.00 0.10 11 0.04999943011540163 0.03161985510812596 0 0 0 6001215 0.0% l_tax DECIMAL(15,2) 0.00 0.08 9 0.0400135089... - https://man.mtool.work/duckdb/1.3/guides/meta/summarize.html
- SQL Introduction – DuckDB 7781
- 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
...h. The temperature fields are stored in an INTEGER type, a type that stores integer numbers (i.e., whole numbers without a decimal point). FLOAT columns store single precision floating-point numbers (i.e., numbers with a decimal point). DATE stores a da...fic day, not a time associated with that day. DuckDB supports the standard SQL types INTEGER , SMALLINT , FLOAT , DOUBLE , DECIMAL , CHAR(n) , VARCHAR(n) , DATE , TIME and TIMESTAMP . The second example will store cities and their associated geographica...l location: CREATE TABLE cities ( name VARCHAR , lat DECIMAL , lon DECIMAL ); Finally, it should be mentioned that if you don't need a table any longer or want to recreate it differen... - https://man.mtool.work/duckdb/1.3/sql/introduction.html
DuckDB 1.3 Documentation / man.mtool.work