Results of 1 - 6 of about 6 for grid (0.003 sec.)
- Timestamp with Time Zone Functions 11314
- 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
...ording to the format string if %Z is specified. time_bucket(bucket_width, timestamptz[, offset]) Truncate timestamptz to a grid of width bucket_width . The grid is anchored at 2000-01-01 00:00:00+00:00[ + offset] when bucket_width is a number of mont...[ + offset] . Note that 2000-01-03 is a Monday. time_bucket(bucket_width, timestamptz[, origin]) Truncate timestamptz to a grid of width bucket_width . The grid is anchored at the origin timestamp, which defaults to 2000-01-01 00:00:00+00:00 when buc...:00+00:00 . Note that 2000-01-03 is a Monday. time_bucket(bucket_width, timestamptz[, timezone]) Truncate timestamptz to a grid of width bucket_width . The grid is anchored at the origin timestamp, which defaults to 2000-01-01 00:00:00 in the provide... - https://man.mtool.work/duckdb/2.0/sql/functions/timestamptz.html
- Date Functions 11205
- 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
...Converts a date to a string according to the format string . time_bucket(bucket_width, date[, offset]) Truncate date to a grid of width bucket_width . The grid is anchored at 2000-01-01[ + offset] when bucket_width is a number of months or coarser u...0-01-03[ + offset] . Note that 2000-01-03 is a Monday. time_bucket(bucket_width, date[, origin]) Truncate timestamptz to a grid of width bucket_width . The grid is anchored at the origin timestamp, which defaults to 2000-01-01 when bucket_width is a...-d %B %Y') | | Result | Wed, 1 January 1992 | time_bucket(bucket_width, date[, offset]) | Description | Truncate date to a grid of width bucket_width . The grid is anchored at 2000-01-01[ + offset] when bucket_width is a number of months or coarser u... - https://man.mtool.work/duckdb/2.0/sql/functions/date.html
- Timestamp Functions 10163
- 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
...lure. To return NULL on failure, use try_strptime . time_bucket(bucket_width, timestamp[, offset]) Truncate timestamp to a grid of width bucket_width . The grid is anchored at 2000-01-01 00:00:00[ + offset] when bucket_width is a number of months or...0:00[ + offset] . Note that 2000-01-03 is a Monday. time_bucket(bucket_width, timestamp[, origin]) Truncate timestamp to a grid of width bucket_width . The grid is anchored at the origin timestamp, which defaults to 2000-01-01 00:00:00 when bucket_wi...| | Result | 1992-01-01 20:38:40 | time_bucket(bucket_width, timestamp[, offset]) | Description | Truncate timestamp to a grid of width bucket_width . The grid includes 2000-01-01 00:00:00[ + offset] when bucket_width is a number of months or coarse... - https://man.mtool.work/duckdb/2.0/sql/functions/timestamp.html
- LibreDB Studio SQL Editor 7750
- LibreDB Studio is an open-source, self-hosted, browser-based SQL editor. It runs as a single server, either via npx , Docker, or a native package, and is reached through the browser rather than installed as a desktop application. LibreDB St
...ton next to the LibreDB Studio logo in the sidebar to open the New Connection dialog. Select DuckDB from the database type grid, and give the connection a name. Enter the path to the DuckDB database file in Database File Path . To use an in-memory da... - https://man.mtool.work/duckdb/2.0/guides/sql_editors/libredb_studio.html
- Spatial Functions 7531
- 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
...always_xy := true ); ---- POINT (544615.0239773799 6867874.103539125) -- Transform a geometry from OSG36 British National Grid EPSG:27700 to EPSG:4326 WGS84 -- Standard transform is often fine for the first few decimal places before being wrong -- w...or starting at about 10m and possibly much more SELECT ST_Transform(bng, 'EPSG:27700', 'EPSG:4326', xy := true) AS without_grid_file FROM (SELECT ST_GeomFromText('POINT( 170370.718 11572.405 )') AS bng); ---- POINT (-5.202992651563592 49.960074901629...23) -- By using an official NTv2 grid file, we can reduce the error down around the 9th decimal place -- which in theory is below a millimetre, and in practice... - https://man.mtool.work/duckdb/2.0/core_extensions/spatial/functions.html
- Configuration 6799
- DuckDB has a number of configuration options that can be used to change the behavior of the system. The configuration options can be set using either the SET statement or the PRAGMA statement . They can be reset to their original values usi
...equest. UBIGINT 4096 external_file_cache_request_sizing How reads of cached files are sized: AUTO lets each reader choose, GRID reads the aligned blocks of the cache block size around each read, EXACT reads exactly the requested bytes. Reads of files... - https://man.mtool.work/duckdb/2.0/configuration/overview.html
PREV
1
NEXT
DuckDB 2.0 Documentation / man.mtool.work