Results of 1 - 8 of about 8 for units (0.005 sec.)
- Interval Type – DuckDB 13411
- 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 TIME values. Name Description INTERVAL Period of time An INTERVAL can be constructed by providing amounts together with units. Units 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 , -- par...r 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... - https://man.mtool.work/duckdb/1.3/sql/data_types/interval.html
- Timestamp with Time Zone Functions – DuckDB 9543
- 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
...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/1.3/sql/functions/timestamptz.html
- Date Functions – DuckDB 9163
- 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
...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 UTC. current_d...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-04-20'... - https://man.mtool.work/duckdb/1.3/sql/functions/date.html
- Timestamp Functions – DuckDB 8766
- 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
...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', TIMEST... - https://man.mtool.work/duckdb/1.3/sql/functions/timestamp.html
- Text Functions – DuckDB 8639
- 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
...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.). formatReadableSize(integer) Converts integer to a human-readable representation...using units based on powers of 2 (KiB, MiB, GiB, etc.). format_bytes(integer) Converts integer to a human-readable representation usin...g units based on powers of 2 (KiB, MiB, GiB, etc.). from_base64(string) Converts a base64 encoded string to a character string ( B... - https://man.mtool.work/duckdb/1.3/sql/functions/text.html
- Spatial Functions – DuckDB 7609
- 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
...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....elopers 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... - https://man.mtool.work/duckdb/1.3/core_extensions/spatial/functions.html
- DuckDB_% Metadata Functions – DuckDB 7609
- 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
...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 approximate numeric t...of bits. For decimal types, this is the number of digits 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 expre... - https://man.mtool.work/duckdb/1.3/sql/meta/duckdb_table_functions.html
- Building Configuration – DuckDB 7482
- 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
...package is 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/1.3/dev/building/build_configuration.html
PREV
1
NEXT
DuckDB 1.3 Documentation / man.mtool.work