⌘K ctrl+k
Search Shortcut cmd + k | ctrl + k
DuckDB 1.3 ドキュメント 全文検索
per page, with , order by , clip by
Results of 1 - 4 of about 4 for degrees (0.004 sec.)
Numeric Functions – DuckDB 12353
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 ... p. ceiling(x) Rounds the number up. Alias of ceil . cos(x) Computes the cosine of x . cot(x) Computes the cotangent of x . degrees(x) Converts radians to degrees. divide(x, y) Alias for x // y . even(x) Round to next even number by rounding away from ze ... pi. pow(x, y) Computes x to the power of y . power(x, y) Alias of pow . Computes x to the power of y . radians(x) Converts degrees to radians. random() Returns a random number x in the range 0.0 <= x < 1.0 . round_even(v NUMERIC, s INTEGER) Alias of rou ... (90) Result -0.4480736161291701 cot(x) Description Computes the cotangent of x . Example cot(0.5) Result 1.830487721712452 degrees(x) Description Converts radians to degrees. Example degrees(pi()) Result 180 divide(x, y) Description Alias for x // y . E ...
https://man.mtool.work/duckdb/1.3/sql/functions/numeric.html
Set Operations – DuckDB 8765
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 ... HAR ); INSERT INTO capitals VALUES ( 'Amsterdam' , 'NL' ), ( 'Berlin' , 'Germany' ); CREATE TABLE weather ( city VARCHAR , degrees INTEGER , date DATE ); INSERT INTO weather VALUES ( 'Amsterdam' , 10 , '2022-10-14' ), ( 'Seattle' , 8 , '2022-10-12' ); S ... ELECT * FROM capitals UNION BY NAME SELECT * FROM weather ; city country degrees date Seattle NULL 8 2022-10-12 Amsterdam NL NULL NULL Berlin Germany NULL NULL Amsterdam NULL 10 2022-10-14 UNION BY NAME ...
https://man.mtool.work/duckdb/1.3/sql/query_syntax/setops.html
Spatial Functions – DuckDB 8303
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 ... POINT_2D ) Description Returns the azimuth (a clockwise angle measured from north) of two points in radian. Example SELECT degrees ( ST_Azimuth ( ST_Point ( 0 , 0 ), ST_Point ( 0 , 1 ))); ---- 90.0 ST_Boundary Signature GEOMETRY ST_Boundary ( geom GEOME ... ion Rotates a geometry around the X axis. This is a shorthand macro for calling ST_Affine. Example -- Rotate a 3D point 90 degrees (π/2 radians) around the X-axis SELECT ST_RotateX ( ST_GeomFromText ( 'POINT Z(0 1 0)' ), pi () / 2 ); ---- POINT Z ( 0 0 ... ion Rotates a geometry around the Y axis. This is a shorthand macro for calling ST_Affine. Example -- Rotate a 3D point 90 degrees (π/2 radians) around the Y-axis SELECT ST_RotateY ( ST_GeomFromText ( 'POINT Z(1 0 0)' ), pi () / 2 ); ---- POINT Z ( 0 0 ...
https://man.mtool.work/duckdb/1.3/core_extensions/spatial/functions.html
SQL Introduction – DuckDB 7526
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 ... ates You can update existing rows using the UPDATE command. Suppose you discover the temperature readings are all off by 2 degrees after November 28. You can correct the data as follows: UPDATE weather SET temp_hi = temp_hi - 2 , temp_lo = temp_lo - 2 W ...
https://man.mtool.work/duckdb/1.3/sql/introduction.html
PREV 1 NEXT
DuckDB 1.3 Documentation / man.mtool.work