Results of 1 - 10 of about 15 for units (0.003 sec.)
- Interval Type 14542
- 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.
...s that aren't months , days , or microseconds are converted to equivalent amounts in the next smaller of these three basis units. SELECT INTERVAL 1 YEAR, -- single unit using YEAR keyword; stored as 12 months INTERVAL (random() * 10) YEAR, -- parenthe...or variable amounts; -- stored as integer number of months INTERVAL '1 month 1 day', -- string type necessary for multiple units; stored as (1 month, 1 day) '16 months'::INTERVAL, -- string cast supported; stored as 16 months '48:00:00'::INTERVAL, --...unit in the string or use a more granular unit; e.g., INTERVAL '1.5 years' or INTERVAL 18 MONTHS . Three independent basis units are necessary because a month does not correspond to a fixed amount of days (February has fewer days than March) and a day... - https://man.mtool.work/duckdb/2.0/sql/data_types/interval.html
- Timestamp with Time Zone Functions 9787
- This section describes functions and operators for examining and manipulating TIMESTAMP WITH TIME ZONE (or TIMESTAMPTZ ) values . See also the related TIMESTAMP functions . Time zone support is provided by the built-in ICU extension . In th
...et_width . The grid is anchored at 2000-01-01 00:00:00+00:00[ + offset] when bucket_width is a number of months or coarser units, else 2000-01-03 00:00:00+00:00[ + offset] . Note that 2000-01-03 is a Monday. time_bucket(bucket_width, timestamptz[, ori...ed at the origin timestamp, which defaults to 2000-01-01 00:00:00+00:00 when bucket_width is a number of months or coarser units, else 2000-01-03 00:00:00+00:00 . Note that 2000-01-03 is a Monday. time_bucket(bucket_width, timestamptz[, timezone]) Tru...mestamp, which defaults to 2000-01-01 00:00:00 in the provided timezone when bucket_width is a number of months or coarser units, else 2000-01-03 00:00:00 in the provided timezone . The default timezone is 'UTC' . Note that 2000-01-03 is a Monday. age... - https://man.mtool.work/duckdb/2.0/sql/functions/timestamptz.html
- Date Functions 9665
- This section describes functions and operators for examining and manipulating DATE values. Date Operators The table below shows the available mathematical operators for DATE types. Operator Description Example Result + addition of days (int
...d of width bucket_width . The grid is anchored at 2000-01-01[ + offset] when bucket_width is a number of months or coarser units, else 2000-01-03[ + offset] . Note that 2000-01-03 is a Monday. time_bucket(bucket_width, date[, origin]) Truncate timesta...grid is anchored at the origin timestamp, which defaults to 2000-01-01 when bucket_width is a number of months or coarser units, else 2000-01-03 . Note that 2000-01-03 is a Monday. today() Current date (start of current transaction) in the local time...d of width bucket_width . The grid is anchored at 2000-01-01[ + offset] when bucket_width is a number of months or coarser units, else 2000-01-03[ + offset] . Note that 2000-01-03 is a Monday. | | Example | time_bucket(INTERVAL '2 months', DATE '1992-... - https://man.mtool.work/duckdb/2.0/sql/functions/date.html
- Metrics 9073
- DuckDB provides a set of metrics that can be used to monitor the performance and health of the database. Metrics are named ⟨group⟩.⟨metric⟩ , e.g., query.total_time or operator.timing . The set of collected metrics is controlled with the tr
...', 'operator.timing'] . By default, all metrics are collected ( ['*'] ). The available metrics, along with their types and units, can be listed with the duckdb_available_metrics() table function: SELECT metric_name, metric_type, unit FROM duckdb_avail...r system.peak_streaming_buffer_size uint64 bytes Peak number of bytes a streaming query result held: queued bytes plus the units blocked workers hold, both exact. Units still under construction are not counted system.peak_temp_dir_size uint64 bytes Pe... - https://man.mtool.work/duckdb/2.0/dev/metrics.html
- Timestamp Functions 9073
- 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
...h bucket_width . The grid is anchored at 2000-01-01 00:00:00[ + offset] when bucket_width is a number of months or coarser units, else 2000-01-03 00:00:00[ + offset] . Note that 2000-01-03 is a Monday. time_bucket(bucket_width, timestamp[, origin]) Tr...anchored at the origin timestamp, which defaults to 2000-01-01 00:00:00 when bucket_width is a number of months or coarser units, else 2000-01-03 00:00:00 . Note that 2000-01-03 is a Monday. try_strptime(text, format-list) Converts the string text to...f width bucket_width . The grid includes 2000-01-01 00:00:00[ + offset] when bucket_width is a number of months 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',... - https://man.mtool.work/duckdb/2.0/sql/functions/timestamp.html
- Interval Functions 8708
- 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
...onds, as double precision floating point number, in interval. normalized_interval(interval) Normalizes an interval so that units that overflow their range are carried over into the next larger unit. to_centuries(integer) Construct a century interval....epoch(INTERVAL 5 HOUR) | | Result | 18000.0 | normalized_interval(interval) | Description | Normalizes an interval so that units that overflow their range are carried over into the next larger unit. | | Example | normalized_interval(INTERVAL '30 days'... - https://man.mtool.work/duckdb/2.0/sql/functions/interval.html
- Text Functions 8237
- Text Functions and Operators This section describes functions and operators for examining and manipulating STRING values . Function Description string[index] Extracts a single character using a (1-based) index . string[begin:end] Extracts a
...string using the fmt syntax . formatReadableDecimalSize(integer) Converts integer to a human-readable representation using units based on powers of 10 (KB, MB, GB, etc.). format_bytes(integer) Converts integer to a human-readable representation using...42 seconds | formatReadableDecimalSize(integer) | Description | Converts integer to a human-readable representation using units based on powers of 10 (KB, MB, GB, etc.). | | Example | formatReadableDecimalSize(16000) | | Result | 16.0 kB | format_byt...es(integer) | Description | Converts integer to a human-readable representation using units based on powers of 2 (KiB, MiB, GiB, etc.). | | Example | format_bytes(16_000) | | Result | 15.6 KiB | | Alias | formatRea... - https://man.mtool.work/duckdb/2.0/sql/functions/text.html
- Building Configuration 7889
- Build Types DuckDB can be built in many different settings, most of these correspond directly to CMake but not all of them. release This build has been stripped of all the assertions and debug symbols and code, optimized for performance. de
...CLI is not built. Miscellaneous Flags DISABLE_UNITY To improve compilation time, we use Unity Build to combine translation units. This can however hide include bugs, this flag disables using the unity build so these errors can be detected. DISABLE_SAN... - https://man.mtool.work/duckdb/2.0/dev/building/build_configuration.html
- Profiling 7889
- Profiling is essential to help understand why certain queries exhibit specific performance characteristics. DuckDB contains several built-in features to enable query profiling, which this page covers. For a high-level example of using EXPLA
....*'] . This replaces the custom_profiling_settings PRAGMA used in earlier versions. The available metric names, types, and units can be listed with the duckdb_available_metrics() table function: sql SELECT metric_name, metric_type, unit FROM duckdb_av... - https://man.mtool.work/duckdb/2.0/dev/profiling.html
- Spatial Functions 7767
- Function Index Scalar Functions Function Summary DuckDB_PROJ_Compiled_Version Returns a text description of the PROJ library version that this instance of DuckDB was compiled against. DuckDB_Proj_Version Returns a text description of the PR
...geometry that is not a POLYGON , MULTIPOLYGON or GEOMETRYCOLLECTION containing polygon geometries. The area is in the same units as the spatial reference system of the geometry. The POINT_2D and LINESTRING_2D overloads of this function always return 0...geometry at the target distance geom is the input geometry. distance is the target distance for the buffer, using the same units as the input geometry. num_triangles represents how many triangles that will be produced to approximate a quarter circle....evelopers SELECT ST_Transform(bng , '+proj=tmerc +lat_0=49 +lon_0=-2 +k=0.9996012717 +x_0=400000 +y_0=-100000 +ellps=airy +units=m +no_defs +nadgrids=/full/path/to/OSTN15-NTv2/OSTN15_NTv2_OSGBtoETRS.gsb +type=crs' , 'EPSG:4326', xy := true) AS with_gr... - https://man.mtool.work/duckdb/2.0/core_extensions/spatial/functions.html
DuckDB 2.0 Documentation / man.mtool.work