Search Result: grid - DuckDB 1.3 全文検索

Search Shortcut cmd + k | ctrl + k

Documentation DuckDB 1.3 ドキュメント全文検索

DuckDB 1.3 ドキュメント全文検索

Results of 1 - 4 of about 4 for grid (0.003 sec.)

Timestamp with Time Zone Functions – DuckDB 10984: 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 ... 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/1.3/sql/functions/timestamptz.html

Date Functions – DuckDB 10577: 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 ... 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 ... -01', '%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/1.3/sql/functions/date.html

Timestamp Functions – DuckDB 9098: 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 ... 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 ... I:%M:%S %p') 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/1.3/sql/functions/timestamp.html

Spatial Functions – DuckDB 6268: 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 ... ways_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 ... ting 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.960074 ... 90162923 ) -- 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 practise ...; https://man.mtool.work/duckdb/1.3/core_extensions/spatial/functions.html

PREV 1 NEXT

DuckDB 1.3 Documentation / man.mtool.work