Results of 1 - 8 of about 8 for minutes (0.005 sec.)
- Relational API – DuckDB 13465
- 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
...e is ', case when mod(range,2)=0 then 'even' else 'uneven' end) as description, range as value, now() + concat(range,' ', 'minutes')::interval as created_timestamp from range(1, 10) """ ) rel . alias Result unnamed_relation_43c808c247431be5 columns Desc...e is ', case when mod(range,2)=0 then 'even' else 'uneven' end) as description, range as value, now() + concat(range,' ', 'minutes')::interval as created_timestamp from range(1, 10) """ ) rel . columns Result ['id', 'description', 'value', 'created_time...e is ', case when mod(range,2)=0 then 'even' else 'uneven' end) as description, range as value, now() + concat(range,' ', 'minutes')::interval as created_timestamp from range(1, 10) """ ) rel . describe () Result ┌─────────┬─────────────────────────────... - https://man.mtool.work/duckdb/1.3/clients/python/relational_api.html
- Date Part Functions – DuckDB 9778
- 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
...mils , millenium 3 milliseconds Sub-minute milliseconds millisecond , ms , msec , msecs , msecond , mseconds 44123 minute Minutes min , minutes , mins , m 59 month Gregorian month mon , months , mons 8 quarter Quarter of the year (1-4) quarters 3 secon...second(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 offset hour portion. timezo...ne_minute(date) Time zone offset minutes portion. timezone(date) Time zone offset in minutes. week(date) ISO Week. weekday(date) Numeric weekday synonym (Sunday =... - https://man.mtool.work/duckdb/1.3/sql/functions/datepart.html
- TPC-H Extension – DuckDB 9073
- 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
...data set using 128 threads. Scale factor Database size Generation time Single-step generation's memory usage 100 26 GB 17 minutes 71 GB 300 78 GB 51 minutes 211 GB 1,000 265 GB 2 h 53 minutes 647 GB 3,000 796 GB 8 h 30 minutes 1799 GB The numbers shown...use a TPC-H framework implementation. 関連キーワード tpch dbgen query step children queries scale factor parameters table minutes extension DuckDB Generating generate defined amount memory generator benchmark Usage existing tables running Listing 関連す... - https://man.mtool.work/duckdb/1.3/core_extensions/tpch.html
- Interval Functions – DuckDB 8368
- 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
...rval. 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 month interval. to_quarters(integer ) Construct an in...seconds(integer) Description Construct a millisecond interval. Example to_milliseconds(5) Result INTERVAL 5 MILLISECOND to_minutes(integer) Description Construct a minute interval. Example to_minutes(5) Result INTERVAL 5 MINUTE to_months(integer) Descri... - https://man.mtool.work/duckdb/1.3/sql/functions/interval.html
- Interval Type – DuckDB 8260
- 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
...ion, the months component is additionally split into years and months, and the microseconds component is split into hours, minutes, and microseconds. The days component is not split into additional units. To demonstrate this, the following query generat...YS + INTERVAL ( random () * 12_345 ) MONTHS ) ) _ ( period ); Warning The microseconds component is split only into hours, minutes, and microseconds, rather than hours, minutes, seconds , and microseconds. Additionally, the amounts of centuries, decades... - https://man.mtool.work/duckdb/1.3/sql/data_types/interval.html
- Timestamp Functions – DuckDB 7790
- 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
...or coarser units, else 2000-01-03 00:00:00[ + offset] . Note that 2000-01-03 is a Monday. Example time_bucket(INTERVAL '10 minutes', TIMESTAMP '1992-04-20 15:26:00-07', INTERVAL '5 minutes') Result 1992-04-20 15:25:00 time_bucket(bucket_width, timestamp... - https://man.mtool.work/duckdb/1.3/sql/functions/timestamp.html
- Timestamp with Time Zone Functions – DuckDB 7790
- 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
...rser units, else 2000-01-03 00:00:00+00:00[ + offset] . Note that 2000-01-03 is a Monday. Example time_bucket(INTERVAL '10 minutes', TIMESTAMPTZ '1992-04-20 15:26:00-07', INTERVAL '5 minutes') Result 1992-04-20 15:25:00-07 time_bucket(bucket_width, time... - https://man.mtool.work/duckdb/1.3/sql/functions/timestamptz.html
- Time Functions – DuckDB 7717
- 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
...e(bigint, bigint, double) The time for the given parts. The only date parts that are defined for times are epoch , hours , minutes , seconds , milliseconds and microseconds . current_time Description Current time (start of current transaction) in the lo... - https://man.mtool.work/duckdb/1.3/sql/functions/time.html
PREV
1
NEXT
DuckDB 1.3 Documentation / man.mtool.work