Results of 1 - 10 of about 22 for milliseconds (0.002 sec.)
- PostgreSQL Extension Functions 12541
- postgres_clear_cache postgres_configure_pool postgres_execute postgres_hstore_get postgres_hstore_to_json postgres_query read_postgres_binary postgres_clear_cache postgres_clear_cache() -> TABLE Clears cached schema entries (like table name
...se. This number can be temporary exceeded when parallel scans are used. wait_timeout_millis ( UBIGINT ): maximum number of milliseconds to wait when acquiring a connection from a pool where all available connections are already taken. enable_thread_local_cac...e available to other threads, while still taking the place in the pool. max_lifetime_millis ( UBIGINT ): maximum number of milliseconds the connection can be kept open. This number is checked when the connection is taken from the pool and returned to the poo...read argument), then this number is checked in background periodically. idle_timeout_millis ( UBIGINT ): maximum number of milliseconds the connection can be kept idle in the pool. This number is checked when the connection is taken from the pool. When the c... - https://man.mtool.work/duckdb/2.0/core_extensions/postgres/functions.html
- Timestamp Functions 11144
- 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
...pecified precision . dayname(timestamp) The (English) name of the weekday. epoch_ms(timestamp) Returns the total number of milliseconds since the epoch. epoch_ns(timestamp) Returns the total number of nanoseconds since the epoch. epoch_us(timestamp) Returns...for the given parts. make_timestamp(microseconds) Converts microseconds since the epoch to a timestamp. make_timestamp_ms(milliseconds) Converts milliseconds since the epoch to a timestamp. make_timestamp_ns(nanoseconds) Converts nanoseconds since the epoch...le | dayname(TIMESTAMP '1992-03-22') | | Result | Sunday | epoch_ms(timestamp) | Description | Returns the total number of milliseconds since the epoch. | | Example | epoch_ms(TIMESTAMP '2021-08-03 11:59:44.123456') | | Result | 1627991984123 | epoch_ns(time... - https://man.mtool.work/duckdb/2.0/sql/functions/timestamp.html
- Interval Type 10942
- INTERVAL s represent periods of time that can be added to or subtracted from DATE , TIMESTAMP , TIMESTAMPTZ , or TIME values. Name Description INTERVAL Period of time An INTERVAL can be constructed by providing amounts together with units.
...croseconds) ; Warning Decimal values are truncated to integers when used with unit keywords (unless the unit is SECONDS or MILLISECONDS ). sql SELECT INTERVAL '1.5' YEARS; -- Returns 12 months; equivalent to `to_years(CAST(trunc(1.5) AS INTEGER))` For more p...d #microseconds % (60 * 1_000_000) Additionally, datepart may be used to extract centuries, decades, quarters, seconds and milliseconds from INTERVAL s. However, these parts are not required when reassembling the original INTERVAL . In fact, if the previous...de', INTERVAL 12 YEARS), -- returns 1 datepart('year', INTERVAL 12 YEARS), -- returns 12 datepart('second', INTERVAL 1_234 MILLISECONDS), -- returns 1 datepart('microsecond', INTERVAL 1_234 MILLISECONDS), -- returns 1_234_000 ; Arithmetic with Timestamps, Da... - https://man.mtool.work/duckdb/2.0/sql/data_types/interval.html
- Date Part Functions 10555
- 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
...c , usecs , usecond , useconds 44123456 millennium Gregorian millennium mil , millenniums , millennia , mils , millenium 3 milliseconds Sub-minute milliseconds millisecond , ms , msec , msecs , msecond , mseconds 44123 minute Minutes min , minutes , mins , m...LE Julian Day number. microsecond(date) Sub-minute microseconds. millennium(date) Millennium. millisecond(date) Sub-minute milliseconds. minute(date) Minutes. month(date) Month. quarter(date) Quarter. second(date) Seconds. timezone_hour(date) Time zone offse...on | Millennium. | | Example | millennium(DATE '1992-02-15') | | Result | 2 | millisecond(date) | Description | Sub-minute milliseconds. | | Example | millisecond(timestamp '2021-08-03 11:59:44.123456') | | Result | 44123 | minute(date) | Description | Minut... - https://man.mtool.work/duckdb/2.0/sql/functions/datepart.html
- Interval Functions 10151
- 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
...rval. to_microseconds(integer) Construct a microsecond interval. to_millennia(integer) Construct a millennium interval. to_milliseconds(integer) Construct a millisecond interval. to_minutes(integer) Construct a minute interval. to_months(integer) Construct a...teger) | Description | Construct a millennium interval. | | Example | to_millennia(5) | | Result | INTERVAL 5000 YEAR | to_milliseconds(integer) | Description | Construct a millisecond interval. | | Example | to_milliseconds(5) | | Result | INTERVAL 5 MILLIS... - https://man.mtool.work/duckdb/2.0/sql/functions/interval.html
- PostgreSQL Extension Connection Pool 9949
- PostgreSQL server spawns a backend process for every incoming client connection. This model leads to the two following points with the postgres extension that can cause performance problems: opening a new connection is relatively expensive
...mporary exceeded when parallel scans are used. pg_pool_wait_timeout_millis ( UBIGINT , default: 30000 ): maximum number of milliseconds to wait when acquiring a connection from a pool where all available connections are already taken. pg_pool_enable_thread_l...le still taking the place in the pool. pg_pool_max_lifetime_millis ( UBIGINT , default: 0 not enforced): maximum number of milliseconds the connection can be kept open. This number is checked when the connection is taken from the pool and returned to the poo...number is checked in background periodically. pg_pool_idle_timeout_millis ( UBIGINT , default: 60000 ): maximum number of milliseconds the connection can be kept idle in the pool. This number is checked when the connection is taken from the pool. When the c... - https://man.mtool.work/duckdb/2.0/core_extensions/postgres/connection_pool.html
- MySQL Extension 9157
- The mysql extension allows DuckDB to directly read and write data from/to a running MySQL instance. The data can be queried directly from the underlying MySQL database. Data can be loaded from MySQL tables into DuckDB tables, or vice versa.
...available), or try (fail immediately if none is available) force mysql_pool_connection_idle_timeout_millis Maximum time in milliseconds a connection can sit idle in the cache before being closed 60000 mysql_pool_connection_max_lifetime_millis Maximum age in...ximum number of connections per MySQL catalog automatic (based on the CPU count) mysql_pool_wait_timeout_millis Timeout in milliseconds when waiting for a connection from the pool 30000 mysql_session_time_zone Session time zone to set for newly opened connec... - https://man.mtool.work/duckdb/2.0/core_extensions/mysql.html
- Utility Functions 8753
- Scalar Utility Functions The functions below are difficult to categorize into specific function types and are broadly useful. Name Description alias(column) Return the name of the column. can_cast_implicitly(source_value, target_value) Whet
...ARCHAR with the SHA-1 hash of the string . sha256(string) Returns a VARCHAR with the SHA-256 hash of the string . sleep_ms(milliseconds) Pause execution for the specified number of milliseconds. Returns NULL . stats(expression) Returns a VARIANT with statist...tring . | | Example | sha256('?') | | Result | d7a5c5e0d1d94c32218539e7e47d4ba9c3c7b77d61332fb60d633dde89e473fb | sleep_ms(milliseconds) | Description | Pause execution for the specified number of milliseconds. Returns NULL . | | Example | sleep_ms(500) | |... - https://man.mtool.work/duckdb/2.0/sql/functions/utility.html
- Agent Mode 7760
- New Agent mode was introduced in DuckDB 2.0. Agent mode renders the CLI's output for consumption by an AI coding agent rather than a human at a terminal. It produces compact Markdown tables with explicit result limits, machine-readable erro
...and prints a summary of agent mode. A few things that help when driving DuckDB programmatically: SET max_execution_time = ⟨milliseconds⟩ bounds how long a query may run. DESCRIBE ⟨query⟩ returns the result columns without running the query. SUMMARIZE ⟨table⟩... - https://man.mtool.work/duckdb/2.0/clients/cli/agent_mode.html
- PostgreSQL Extension 7760
- 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
...or not to use filter pushdown true pg_idle_in_transaction_timeout_millis PostgreSQL idle_in_transaction_session_timeout in milliseconds to set on scan connections NULL pg_null_byte_replacement When writing NULL bytes to PostgreSQL, replace them with the give...'COPY_BINARY' , 'PLAIN_QUERY_BINARY' , 'PLAIN_QUERY_TEXT' AUTO pg_statement_timeout_millis PostgreSQL statement timeout in milliseconds to set on scan connections NULL pg_use_binary_copy Whether or not to use BINARY copy to read data true pg_use_ctid_scan Wh... - https://man.mtool.work/duckdb/2.0/core_extensions/postgres/overview.html
DuckDB 2.0 Documentation / man.mtool.work