Results of 1 - 6 of about 6 for clock (0.001 sec.)
- Date Format Functions 12886
- The strftime and strptime functions can be used to convert between DATE / TIMESTAMP values and strings. This is often required when parsing CSV files, displaying output to the user or transferring information between programs. Because there
...ar that contains the greater part 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 decimal number. 01, 02, ..., 12 %-I Hour (12-hour clock) as a decimal number. 1, 2, ... 12 %j Day of the... - https://man.mtool.work/duckdb/2.0/sql/functions/dateformat.html
- Profiling Queries 9523
- DuckDB supports profiling queries via the EXPLAIN and EXPLAIN ANALYZE statements. EXPLAIN To see the query plan of a query without executing it, run: EXPLAIN ⟨query⟩; The output of EXPLAIN contains the estimated cardinalities for each opera
...AIN ANALYZE statement runs the query, and shows the actual cardinalities for each operator, as well as the cumulative wall-clock time spent in each operator.... - https://man.mtool.work/duckdb/2.0/sql/statements/profiling.html
- EXPLAIN ANALYZE: Profile Queries 8810
- Prepending a query with EXPLAIN ANALYZE both pretty-prints the query plan, and executes it, providing run-time performance numbers and the actual cardinality (number of rows produced) for every operator. EXPLAIN ANALYZE SELECT * FROM tbl; N
...ote that the cumulative wall-clock time that is spent on every operator is shown. When multiple threads are processing the query in parallel, the total proce... - https://man.mtool.work/duckdb/2.0/guides/meta/explain_analyze.html
- Iceberg Options 8573
- This page lists the options of the iceberg extension: the parameters accepted by the Iceberg functions , the options of the ATTACH and CREATE SECRET statements used to connect to a catalog , and the global settings. ATTACH Options To make a
...stead of a bound expression per delete row. Unsupported types fall back to the expression-based path. iceberg_metadata_log_clock_skew_ms BIGINT 0 Clock-skew allowance in milliseconds when iceberg_use_metadata_log is enabled. Table metadata written up... - https://man.mtool.work/duckdb/2.0/core_extensions/iceberg/iceberg_options.html
- Timestamp Types 7604
- 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
...e of bins containing the offset from UTC is needed: Time Zone Support The TIMESTAMPTZ type can be binned into calendar and clock bins using a suitable extension. The built-in icu extension implements all the binning and arithmetic functions using time... - https://man.mtool.work/duckdb/2.0/sql/data_types/timestamp.html
- Pragmas 7366
- The PRAGMA statement is a SQL extension adopted by DuckDB from SQLite. PRAGMA statements can be issued in a similar manner to regular SQL statements. PRAGMA commands may alter the internal state of the database engine, and can influence the
...ry execution: SET threads = 4; Maximum Execution Time New As of DuckDB 2.0, the max_execution_time setting bounds the wall-clock time of a query in milliseconds. When the limit is exceeded, the query is aborted with the error Query exceeded maximum ex... - https://man.mtool.work/duckdb/2.0/configuration/pragmas.html
PREV
1
NEXT
DuckDB 2.0 Documentation / man.mtool.work