Results of 1 - 10 of about 25 for precision (0.006 sec.)
- Timestamp Types 15077
- Timestamps represent points in time. As such, they combine DATE and TIME information. They can be created using the type name followed by a string formatted according to the ISO 8601 format, YYYY-MM-DD hh:mm:ss[.zzzzzzzzz][+-TT[:tt]] , whic
...h is also the format we use in this documentation. Decimal places beyond the supported precision are ignored. Timestamp Types Name Aliases Description TIMESTAMP_NS Naive timestamp with nanosecond precision TIMESTAMP DAT...ETIME , TIMESTAMP WITHOUT TIME ZONE Naive timestamp with microsecond precision TIMESTAMP_MS Naive timestamp with millisecond precision TIMESTAMP_S Naive timestamp with second precision TIMESTAMPTZ TIME...STAMP WITH TIME ZONE Time zone aware timestamp with microsecond precision TIMESTAMPTZ_NS Time zone aware timestamp with nanosecond precision New The TIMESTAMPTZ_NS type was introduced in DuckDB 2.... - https://man.mtool.work/duckdb/2.0/sql/data_types/timestamp.html
- Numeric Types 10627
- 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
...or below, unless there is a good 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 (single and double precision, respectively), to the extent that the underlying processor, operating system, and compiler support it. Name Aliases Descr...iption FLOAT FLOAT4 , REAL Single precision floating-point number (4 bytes) DOUBLE FLOAT8 Double precision floating-point number (8 bytes) Like for fixed-point data t... - https://man.mtool.work/duckdb/2.0/sql/data_types/numeric.html
- Data Types 9963
- General-Purpose Data Types The table below shows all the built-in general-purpose data types. The alternatives listed in the aliases column can be used to refer to these types as well, however, note that the aliases are not part of the SQL
...CAL 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 FLOAT8 Double precision floa...ting-point number (8 bytes) FLOAT FLOAT4 , REAL Single precision floating-point number (4 bytes) GEOMETRY Geospatial entity, see the GEOMETRY data type HUGEINT Signed sixteen-byte integer... - https://man.mtool.work/duckdb/2.0/sql/data_types/overview.html
- Information Schema 9514
- 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
...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 for this col...umn. The precision indicates the number of significant digits. For all other data types, this column is NULL . INTEGER 18 numeric_scale If da...indicates the number of digits after the decimal point. For all other data types, this column is NULL . INTEGER 2 datetime_precision If data_type identifies a date, time, timestamp, or interval type, this column contains the (declared or implicit) fractio... - https://man.mtool.work/duckdb/2.0/sql/meta/information_schema.html
- ODBC Extension Functions 8966
- odbc_begin_transaction odbc_bind_params odbc_close odbc_commit odbc_connect odbc_copy odbc_create_params odbc_list_data_sources odbc_list_drivers odbc_query odbc_rollback odbc_begin_transaction odbc_begin_transaction(conn_handle BIGINT) ->
...se ): read DECIMAL values as VARCHAR s that are parsed back into DECIMAL s before returning them to client decimal_columns_precision_through_ard ( BOOLEAN , default: false ): when reading a DECIMAL specify its precision and scale through "Application Row...t: false ): read TIMESTAMP -like ( TIMESTAMP WITH LOCAL TIME ZONE , DATETIME2 , TIMESTAMP_NTZ etc) columns with nanosecond precision (with nine fractional digits) timestamp_columns_with_typename_date_as_date ( BOOLEAN , default: false ): read TIMESTAMP co...lumns that have a type name DATE as DuckDB DATE s timestamp_max_fraction_precision ( UTINYINT , default: 9 ): maximum number of fractional digits to use when reading a TIMESTAMP column with nanosecond prec... - https://man.mtool.work/duckdb/2.0/core_extensions/odbc/functions.html
- DuckDB_% Metadata Functions 8734
- 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
...lways 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 integral and a...imate numeric types, this is the number of bits. For decimal types, this is the number of digit positions. INTEGER numeric_precision_radix 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 number of bits. For the decimal type this is 10 , indicating the precision is expressed as a number of d... - https://man.mtool.work/duckdb/2.0/sql/meta/duckdb_table_functions.html
- Querying Parquet Files 8518
- To run a query directly on a Parquet file, use the read_parquet function in the FROM clause of a query. SELECT * FROM read_parquet('input.parquet'); The Parquet file will be processed in parallel. Filters will be automatically pushed down i
...n, and only the relevant columns will be read automatically. For more information see the blog post “Querying Parquet with Precision using DuckDB” .... - https://man.mtool.work/duckdb/2.0/guides/file_formats/query_parquet.html
- Reading and Writing Parquet Files 8186
- Examples Read a single Parquet file: SELECT * FROM 'test.parquet'; Figure out which columns/types are in a Parquet file: DESCRIBE SELECT * FROM 'test.parquet'; Create a table from a Parquet file: CREATE TABLE test AS SELECT * FROM 'test.par
...ted timestamp encoding used by legacy writers such as Impala and older Spark versions). Options are timestamp (microsecond precision), timestamp_ns (preserves nanoseconds; out-of-range values saturate) and struct (a STRUCT(date DATE, time TIME_NS) that pr...eserves the full range and precision). Added in DuckDB 2.0. VARCHAR timestamp prefetch_strategy Strategy for prefetching column data of row groups (applies unl...onemaps. Filter and projection pushdown provide significant performance benefits. See our blog post “Querying Parquet with Precision Using DuckDB” for more information. Inserts and Views You can also insert the data into a table or create a table from the... - https://man.mtool.work/duckdb/2.0/data/parquet/overview.html
- Interval Functions 8186
- This section describes functions and operators for examining and manipulating INTERVAL values. Interval Operators The table below shows the available mathematical operators for INTERVAL types. Operator Description Example Result + Addition
...ias of date_part . extract(part FROM interval) Alias of date_part . epoch(interval) Get total number of seconds, as double precision floating point number, in interval. normalized_interval(interval) Normalizes an interval so that units that overflow their...'month' FROM INTERVAL '14 months') | | Result | 2 | epoch(interval) | Description | Get total number of seconds, as double precision floating point number, in interval. | | Example | epoch(INTERVAL 5 HOUR) | | Result | 18000.0 | normalized_interval(interv... - https://man.mtool.work/duckdb/2.0/sql/functions/interval.html
- Timestamp Functions 8070
- This section describes functions and operators for examining and manipulating TIMESTAMP values . See also the related TIMESTAMPTZ functions . Timestamp Operators The table below shows the available mathematical operators for TIMESTAMP types
...starttimestamp and endtimestamp , truncated to whole multiples of part . date_trunc(part, timestamp) Truncate to specified precision . dayname(timestamp) The (English) name of the weekday. epoch_ms(timestamp) Returns the total number of milliseconds since...9:59', TIMESTAMP '1992-10-01 01:58:00') | | Result | 1 | date_trunc(part, timestamp) | Description | Truncate to specified precision . | | Example | date_trunc('hour', TIMESTAMP '1992-09-20 20:38:40') | | Result | 1992-09-20 20:00:00 | dayname(timestamp)...| Unlike epoch_ms , epoch_us and epoch_ns , which return BIGINT , epoch returns a DOUBLE and therefore retains sub-second precision. extract(field FROM timestamp) | Description | Get subfield from a timestamp. | | Example | extract('hour' FROM TIMESTAMP... - https://man.mtool.work/duckdb/2.0/sql/functions/timestamp.html
DuckDB 2.0 Documentation / man.mtool.work