This is an automated email from the ASF dual-hosted git repository. kassiez pushed a commit to branch master in repository https://gitbox.apache.org/repos/asf/doris-website.git
The following commit(s) were added to refs/heads/master by this push: new 38dd78d03e4 [doc] Modify the documentation of functions degrees dexp dfloor dlog1 dlog10 (#1813) 38dd78d03e4 is described below commit 38dd78d03e4a58be2878b5468f5cf689491d199e Author: Mryange <2319153...@qq.com> AuthorDate: Fri Feb 7 16:36:34 2025 +0800 [doc] Modify the documentation of functions degrees dexp dfloor dlog1 dlog10 (#1813) ## Versions - [x] dev - [x] 3.0 - [x] 2.1 - [x] 2.0 ## Languages - [x] Chinese - [x] English ## Docs Checklist - [ ] Checked by AI - [ ] Test Cases Built --- .../scalar-functions/numeric-functions/degrees.md | 56 ++++++++++++---------- .../scalar-functions/numeric-functions/dfloor.md | 6 --- .../scalar-functions/numeric-functions/dlog10.md | 6 --- .../scalar-functions/numeric-functions/degrees.md | 54 +++++++++++---------- .../scalar-functions/numeric-functions/dfloor.md | 6 --- .../scalar-functions/numeric-functions/dlog10.md | 6 --- .../sql-functions/math-functions/degrees.md | 54 +++++++++++---------- .../sql-functions/numeric-functions/degrees.md | 54 +++++++++++---------- .../scalar-functions/numeric-functions/degrees.md | 54 +++++++++++---------- .../scalar-functions/numeric-functions/dfloor.md | 6 --- .../scalar-functions/numeric-functions/dlog10.md | 6 --- .../scalar-functions/numeric-functions/degrees.md | 54 +++++++++++---------- .../scalar-functions/numeric-functions/dfloor.md | 6 --- .../scalar-functions/numeric-functions/dlog10.md | 6 --- sidebars.json | 2 - .../sql-functions/math-functions/degrees.md | 56 ++++++++++++---------- .../sql-functions/numeric-functions/degrees.md | 56 ++++++++++++---------- .../scalar-functions/numeric-functions/degrees.md | 56 ++++++++++++---------- .../scalar-functions/numeric-functions/dfloor.md | 6 --- .../scalar-functions/numeric-functions/dlog10.md | 6 --- .../scalar-functions/numeric-functions/degrees.md | 56 ++++++++++++---------- .../scalar-functions/numeric-functions/dfloor.md | 6 --- .../scalar-functions/numeric-functions/dlog10.md | 6 --- versioned_sidebars/version-2.1-sidebars.json | 2 - versioned_sidebars/version-3.0-sidebars.json | 2 - 25 files changed, 295 insertions(+), 333 deletions(-) diff --git a/docs/sql-manual/sql-functions/scalar-functions/numeric-functions/degrees.md b/docs/sql-manual/sql-functions/scalar-functions/numeric-functions/degrees.md index d646e503ccb..a9efbe92cce 100644 --- a/docs/sql-manual/sql-functions/scalar-functions/numeric-functions/degrees.md +++ b/docs/sql-manual/sql-functions/scalar-functions/numeric-functions/degrees.md @@ -22,36 +22,40 @@ specific language governing permissions and limitations under the License. --> -## degrees +## Description -### description -#### Syntax +Input a double-precision floating-point number and convert it from radians to degrees. -`DOUBLE degrees(DOUBLE x)` -Returns the degree of `x`, converted from radians to degrees. +- When the parameter is NULL, return NULL. -### example +## Syntax +```sql +DEGREES(<a>) ``` -mysql> select degrees(0); -+--------------+ -| degrees(0.0) | -+--------------+ -| 0 | -+--------------+ -mysql> select degrees(2); -+--------------------+ -| degrees(2.0) | -+--------------------+ -| 114.59155902616465 | -+--------------------+ -mysql> select degrees(Pi()); -+---------------+ -| degrees(pi()) | -+---------------+ -| 180 | -+---------------+ + +## Parameters + +| parameter | explain | +| -- | -- | +| `<a>` | The value that needs to be converted from radians to degrees. | + +## Return Value + +The angle of parameter a. + +- When the parameter is NULL, return NULL. + +## Examples + +```sql +select degrees(3.14),degrees(1),degrees(-1),degrees(NULL) ``` -### keywords - DEGREES +```text ++-------------------------------+----------------------------+-----------------------------+---------------+ +| degrees(cast(3.14 as DOUBLE)) | degrees(cast(1 as DOUBLE)) | degrees(cast(-1 as DOUBLE)) | degrees(NULL) | ++-------------------------------+----------------------------+-----------------------------+---------------+ +| 179.9087476710785 | 57.29577951308232 | -57.29577951308232 | NULL | ++-------------------------------+----------------------------+-----------------------------+---------------+ +``` \ No newline at end of file diff --git a/docs/sql-manual/sql-functions/scalar-functions/numeric-functions/dfloor.md b/docs/sql-manual/sql-functions/scalar-functions/numeric-functions/dfloor.md deleted file mode 100644 index 7ad992dac15..00000000000 --- a/docs/sql-manual/sql-functions/scalar-functions/numeric-functions/dfloor.md +++ /dev/null @@ -1,6 +0,0 @@ ---- -{ - "title": "DFLOOR", - "language": "zh-CN" -} ---- diff --git a/docs/sql-manual/sql-functions/scalar-functions/numeric-functions/dlog10.md b/docs/sql-manual/sql-functions/scalar-functions/numeric-functions/dlog10.md deleted file mode 100644 index d24692aac13..00000000000 --- a/docs/sql-manual/sql-functions/scalar-functions/numeric-functions/dlog10.md +++ /dev/null @@ -1,6 +0,0 @@ ---- -{ - "title": "DLOG10", - "language": "zh-CN" -} ---- diff --git a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/numeric-functions/degrees.md b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/numeric-functions/degrees.md index f8b2dbf986d..aa1f21d995a 100644 --- a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/numeric-functions/degrees.md +++ b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/numeric-functions/degrees.md @@ -22,36 +22,40 @@ specific language governing permissions and limitations under the License. --> -## degrees - ## 描述 + +输入一个 double 类型的浮点数,由弧度转换为角度。 + +- 当参数为 NUL 时,返回 NULL + ## 语法 -`DOUBLE degrees(DOUBLE x)` -返回`x`的度, 从弧度转换为度. +```sql +DEGREES(<a>) +``` + +## 参数 + +| 参数 | 说明 | +| -- | -- | +| `<a>` | 需要由弧度转换为角度的值 | + +## 返回值 + +参数 a 的角度 + +- 当参数为 NUL 时,返回 NULL ## 举例 -``` -mysql> select degrees(0); -+--------------+ -| degrees(0.0) | -+--------------+ -| 0 | -+--------------+ -mysql> select degrees(2); -+--------------------+ -| degrees(2.0) | -+--------------------+ -| 114.59155902616465 | -+--------------------+ -mysql> select degrees(Pi()); -+---------------+ -| degrees(pi()) | -+---------------+ -| 180 | -+---------------+ +```sql +select degrees(3.14),degrees(1),degrees(-1),degrees(NULL) ``` -### keywords - DEGREES +```text ++-------------------------------+----------------------------+-----------------------------+---------------+ +| degrees(cast(3.14 as DOUBLE)) | degrees(cast(1 as DOUBLE)) | degrees(cast(-1 as DOUBLE)) | degrees(NULL) | ++-------------------------------+----------------------------+-----------------------------+---------------+ +| 179.9087476710785 | 57.29577951308232 | -57.29577951308232 | NULL | ++-------------------------------+----------------------------+-----------------------------+---------------+ +``` \ No newline at end of file diff --git a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/numeric-functions/dfloor.md b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/numeric-functions/dfloor.md deleted file mode 100644 index 7ad992dac15..00000000000 --- a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/numeric-functions/dfloor.md +++ /dev/null @@ -1,6 +0,0 @@ ---- -{ - "title": "DFLOOR", - "language": "zh-CN" -} ---- diff --git a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/numeric-functions/dlog10.md b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/numeric-functions/dlog10.md deleted file mode 100644 index d24692aac13..00000000000 --- a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/numeric-functions/dlog10.md +++ /dev/null @@ -1,6 +0,0 @@ ---- -{ - "title": "DLOG10", - "language": "zh-CN" -} ---- diff --git a/i18n/zh-CN/docusaurus-plugin-content-docs/version-1.2/sql-manual/sql-functions/math-functions/degrees.md b/i18n/zh-CN/docusaurus-plugin-content-docs/version-1.2/sql-manual/sql-functions/math-functions/degrees.md index 75d2d337536..877ff05cbce 100644 --- a/i18n/zh-CN/docusaurus-plugin-content-docs/version-1.2/sql-manual/sql-functions/math-functions/degrees.md +++ b/i18n/zh-CN/docusaurus-plugin-content-docs/version-1.2/sql-manual/sql-functions/math-functions/degrees.md @@ -22,36 +22,40 @@ specific language governing permissions and limitations under the License. --> -## degrees - ## 描述 + +输入一个 double 类型的浮点数,由弧度转换为角度。 + +- 当参数为 NUL 时,返回 NULL + ## 语法 -`DOUBLE degrees(DOUBLE x)` -返回`x`的度, 从弧度转换为度. +```sql +DEGREES(<a>) +``` + +## 参数 + +| 参数 | 说明 | +| -- | -- | +| `<a>` | 需要由弧度转换为角度的值 | + +## 返回值 + +参数 a 的角度 + +- 当参数为 NUL 时,返回 NULL ## 举例 -``` -mysql> select degrees(0); -+--------------+ -| degrees(0.0) | -+--------------+ -| 0 | -+--------------+ -mysql> select degrees(2); -+--------------------+ -| degrees(2.0) | -+--------------------+ -| 114.59155902616465 | -+--------------------+ -mysql> select degrees(Pi()); -+---------------+ -| degrees(pi()) | -+---------------+ -| 180 | -+---------------+ +```sql +select degrees(3.14),degrees(1),degrees(-1),degrees(NULL) ``` -### keywords - DEGREES +```text ++-------------------------------+----------------------------+-----------------------------+---------------+ +| degrees(cast(3.14 as DOUBLE)) | degrees(cast(1 as DOUBLE)) | degrees(cast(-1 as DOUBLE)) | degrees(NULL) | ++-------------------------------+----------------------------+-----------------------------+---------------+ +| 179.9087476710785 | 57.29577951308232 | -57.29577951308232 | NULL | ++-------------------------------+----------------------------+-----------------------------+---------------+ +``` \ No newline at end of file diff --git a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.0/sql-manual/sql-functions/numeric-functions/degrees.md b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.0/sql-manual/sql-functions/numeric-functions/degrees.md index f8b2dbf986d..aa1f21d995a 100644 --- a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.0/sql-manual/sql-functions/numeric-functions/degrees.md +++ b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.0/sql-manual/sql-functions/numeric-functions/degrees.md @@ -22,36 +22,40 @@ specific language governing permissions and limitations under the License. --> -## degrees - ## 描述 + +输入一个 double 类型的浮点数,由弧度转换为角度。 + +- 当参数为 NUL 时,返回 NULL + ## 语法 -`DOUBLE degrees(DOUBLE x)` -返回`x`的度, 从弧度转换为度. +```sql +DEGREES(<a>) +``` + +## 参数 + +| 参数 | 说明 | +| -- | -- | +| `<a>` | 需要由弧度转换为角度的值 | + +## 返回值 + +参数 a 的角度 + +- 当参数为 NUL 时,返回 NULL ## 举例 -``` -mysql> select degrees(0); -+--------------+ -| degrees(0.0) | -+--------------+ -| 0 | -+--------------+ -mysql> select degrees(2); -+--------------------+ -| degrees(2.0) | -+--------------------+ -| 114.59155902616465 | -+--------------------+ -mysql> select degrees(Pi()); -+---------------+ -| degrees(pi()) | -+---------------+ -| 180 | -+---------------+ +```sql +select degrees(3.14),degrees(1),degrees(-1),degrees(NULL) ``` -### keywords - DEGREES +```text ++-------------------------------+----------------------------+-----------------------------+---------------+ +| degrees(cast(3.14 as DOUBLE)) | degrees(cast(1 as DOUBLE)) | degrees(cast(-1 as DOUBLE)) | degrees(NULL) | ++-------------------------------+----------------------------+-----------------------------+---------------+ +| 179.9087476710785 | 57.29577951308232 | -57.29577951308232 | NULL | ++-------------------------------+----------------------------+-----------------------------+---------------+ +``` \ No newline at end of file diff --git a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/sql-functions/scalar-functions/numeric-functions/degrees.md b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/sql-functions/scalar-functions/numeric-functions/degrees.md index f8b2dbf986d..aa1f21d995a 100644 --- a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/sql-functions/scalar-functions/numeric-functions/degrees.md +++ b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/sql-functions/scalar-functions/numeric-functions/degrees.md @@ -22,36 +22,40 @@ specific language governing permissions and limitations under the License. --> -## degrees - ## 描述 + +输入一个 double 类型的浮点数,由弧度转换为角度。 + +- 当参数为 NUL 时,返回 NULL + ## 语法 -`DOUBLE degrees(DOUBLE x)` -返回`x`的度, 从弧度转换为度. +```sql +DEGREES(<a>) +``` + +## 参数 + +| 参数 | 说明 | +| -- | -- | +| `<a>` | 需要由弧度转换为角度的值 | + +## 返回值 + +参数 a 的角度 + +- 当参数为 NUL 时,返回 NULL ## 举例 -``` -mysql> select degrees(0); -+--------------+ -| degrees(0.0) | -+--------------+ -| 0 | -+--------------+ -mysql> select degrees(2); -+--------------------+ -| degrees(2.0) | -+--------------------+ -| 114.59155902616465 | -+--------------------+ -mysql> select degrees(Pi()); -+---------------+ -| degrees(pi()) | -+---------------+ -| 180 | -+---------------+ +```sql +select degrees(3.14),degrees(1),degrees(-1),degrees(NULL) ``` -### keywords - DEGREES +```text ++-------------------------------+----------------------------+-----------------------------+---------------+ +| degrees(cast(3.14 as DOUBLE)) | degrees(cast(1 as DOUBLE)) | degrees(cast(-1 as DOUBLE)) | degrees(NULL) | ++-------------------------------+----------------------------+-----------------------------+---------------+ +| 179.9087476710785 | 57.29577951308232 | -57.29577951308232 | NULL | ++-------------------------------+----------------------------+-----------------------------+---------------+ +``` \ No newline at end of file diff --git a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/sql-functions/scalar-functions/numeric-functions/dfloor.md b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/sql-functions/scalar-functions/numeric-functions/dfloor.md deleted file mode 100644 index 7ad992dac15..00000000000 --- a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/sql-functions/scalar-functions/numeric-functions/dfloor.md +++ /dev/null @@ -1,6 +0,0 @@ ---- -{ - "title": "DFLOOR", - "language": "zh-CN" -} ---- diff --git a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/sql-functions/scalar-functions/numeric-functions/dlog10.md b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/sql-functions/scalar-functions/numeric-functions/dlog10.md deleted file mode 100644 index d24692aac13..00000000000 --- a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/sql-functions/scalar-functions/numeric-functions/dlog10.md +++ /dev/null @@ -1,6 +0,0 @@ ---- -{ - "title": "DLOG10", - "language": "zh-CN" -} ---- diff --git a/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/sql-manual/sql-functions/scalar-functions/numeric-functions/degrees.md b/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/sql-manual/sql-functions/scalar-functions/numeric-functions/degrees.md index f8b2dbf986d..aa1f21d995a 100644 --- a/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/sql-manual/sql-functions/scalar-functions/numeric-functions/degrees.md +++ b/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/sql-manual/sql-functions/scalar-functions/numeric-functions/degrees.md @@ -22,36 +22,40 @@ specific language governing permissions and limitations under the License. --> -## degrees - ## 描述 + +输入一个 double 类型的浮点数,由弧度转换为角度。 + +- 当参数为 NUL 时,返回 NULL + ## 语法 -`DOUBLE degrees(DOUBLE x)` -返回`x`的度, 从弧度转换为度. +```sql +DEGREES(<a>) +``` + +## 参数 + +| 参数 | 说明 | +| -- | -- | +| `<a>` | 需要由弧度转换为角度的值 | + +## 返回值 + +参数 a 的角度 + +- 当参数为 NUL 时,返回 NULL ## 举例 -``` -mysql> select degrees(0); -+--------------+ -| degrees(0.0) | -+--------------+ -| 0 | -+--------------+ -mysql> select degrees(2); -+--------------------+ -| degrees(2.0) | -+--------------------+ -| 114.59155902616465 | -+--------------------+ -mysql> select degrees(Pi()); -+---------------+ -| degrees(pi()) | -+---------------+ -| 180 | -+---------------+ +```sql +select degrees(3.14),degrees(1),degrees(-1),degrees(NULL) ``` -### keywords - DEGREES +```text ++-------------------------------+----------------------------+-----------------------------+---------------+ +| degrees(cast(3.14 as DOUBLE)) | degrees(cast(1 as DOUBLE)) | degrees(cast(-1 as DOUBLE)) | degrees(NULL) | ++-------------------------------+----------------------------+-----------------------------+---------------+ +| 179.9087476710785 | 57.29577951308232 | -57.29577951308232 | NULL | ++-------------------------------+----------------------------+-----------------------------+---------------+ +``` \ No newline at end of file diff --git a/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/sql-manual/sql-functions/scalar-functions/numeric-functions/dfloor.md b/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/sql-manual/sql-functions/scalar-functions/numeric-functions/dfloor.md deleted file mode 100644 index 7ad992dac15..00000000000 --- a/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/sql-manual/sql-functions/scalar-functions/numeric-functions/dfloor.md +++ /dev/null @@ -1,6 +0,0 @@ ---- -{ - "title": "DFLOOR", - "language": "zh-CN" -} ---- diff --git a/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/sql-manual/sql-functions/scalar-functions/numeric-functions/dlog10.md b/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/sql-manual/sql-functions/scalar-functions/numeric-functions/dlog10.md deleted file mode 100644 index d24692aac13..00000000000 --- a/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/sql-manual/sql-functions/scalar-functions/numeric-functions/dlog10.md +++ /dev/null @@ -1,6 +0,0 @@ ---- -{ - "title": "DLOG10", - "language": "zh-CN" -} ---- diff --git a/sidebars.json b/sidebars.json index a1689aa63ee..e80953d76bf 100644 --- a/sidebars.json +++ b/sidebars.json @@ -900,8 +900,6 @@ "sql-manual/sql-functions/scalar-functions/numeric-functions/cosh", "sql-manual/sql-functions/scalar-functions/numeric-functions/conv", "sql-manual/sql-functions/scalar-functions/numeric-functions/degrees", - "sql-manual/sql-functions/scalar-functions/numeric-functions/dfloor", - "sql-manual/sql-functions/scalar-functions/numeric-functions/dlog10", "sql-manual/sql-functions/scalar-functions/numeric-functions/dround", "sql-manual/sql-functions/scalar-functions/numeric-functions/dsqrt", "sql-manual/sql-functions/scalar-functions/numeric-functions/e", diff --git a/versioned_docs/version-1.2/sql-manual/sql-functions/math-functions/degrees.md b/versioned_docs/version-1.2/sql-manual/sql-functions/math-functions/degrees.md index 97bd537ba04..b463db0bfff 100644 --- a/versioned_docs/version-1.2/sql-manual/sql-functions/math-functions/degrees.md +++ b/versioned_docs/version-1.2/sql-manual/sql-functions/math-functions/degrees.md @@ -22,36 +22,40 @@ specific language governing permissions and limitations under the License. --> -## degrees +## Description -### description -#### Syntax +Input a double-precision floating-point number and convert it from radians to degrees. -`DOUBLE degrees(DOUBLE x)` -Returns the degree of `x`, converted from radians to degrees. +- When the parameter is NULL, return NULL. -### example +## Syntax +```sql +DEGREES(<a>) ``` -mysql> select degrees(0); -+--------------+ -| degrees(0.0) | -+--------------+ -| 0 | -+--------------+ -mysql> select degrees(2); -+--------------------+ -| degrees(2.0) | -+--------------------+ -| 114.59155902616465 | -+--------------------+ -mysql> select degrees(Pi()); -+---------------+ -| degrees(pi()) | -+---------------+ -| 180 | -+---------------+ + +## Parameters + +| parameter | explain | +| -- | -- | +| `<a>` | The value that needs to be converted from radians to degrees. | + +## Return Value + +The angle of parameter a. + +- When the parameter is NULL, return NULL. + +## Examples + +```sql +select degrees(3.14),degrees(1),degrees(-1),degrees(NULL) ``` -### keywords - DEGREES +```text ++-------------------------------+----------------------------+-----------------------------+---------------+ +| degrees(cast(3.14 as DOUBLE)) | degrees(cast(1 as DOUBLE)) | degrees(cast(-1 as DOUBLE)) | degrees(NULL) | ++-------------------------------+----------------------------+-----------------------------+---------------+ +| 179.9087476710785 | 57.29577951308232 | -57.29577951308232 | NULL | ++-------------------------------+----------------------------+-----------------------------+---------------+ +``` \ No newline at end of file diff --git a/versioned_docs/version-2.0/sql-manual/sql-functions/numeric-functions/degrees.md b/versioned_docs/version-2.0/sql-manual/sql-functions/numeric-functions/degrees.md index d646e503ccb..a9efbe92cce 100644 --- a/versioned_docs/version-2.0/sql-manual/sql-functions/numeric-functions/degrees.md +++ b/versioned_docs/version-2.0/sql-manual/sql-functions/numeric-functions/degrees.md @@ -22,36 +22,40 @@ specific language governing permissions and limitations under the License. --> -## degrees +## Description -### description -#### Syntax +Input a double-precision floating-point number and convert it from radians to degrees. -`DOUBLE degrees(DOUBLE x)` -Returns the degree of `x`, converted from radians to degrees. +- When the parameter is NULL, return NULL. -### example +## Syntax +```sql +DEGREES(<a>) ``` -mysql> select degrees(0); -+--------------+ -| degrees(0.0) | -+--------------+ -| 0 | -+--------------+ -mysql> select degrees(2); -+--------------------+ -| degrees(2.0) | -+--------------------+ -| 114.59155902616465 | -+--------------------+ -mysql> select degrees(Pi()); -+---------------+ -| degrees(pi()) | -+---------------+ -| 180 | -+---------------+ + +## Parameters + +| parameter | explain | +| -- | -- | +| `<a>` | The value that needs to be converted from radians to degrees. | + +## Return Value + +The angle of parameter a. + +- When the parameter is NULL, return NULL. + +## Examples + +```sql +select degrees(3.14),degrees(1),degrees(-1),degrees(NULL) ``` -### keywords - DEGREES +```text ++-------------------------------+----------------------------+-----------------------------+---------------+ +| degrees(cast(3.14 as DOUBLE)) | degrees(cast(1 as DOUBLE)) | degrees(cast(-1 as DOUBLE)) | degrees(NULL) | ++-------------------------------+----------------------------+-----------------------------+---------------+ +| 179.9087476710785 | 57.29577951308232 | -57.29577951308232 | NULL | ++-------------------------------+----------------------------+-----------------------------+---------------+ +``` \ No newline at end of file diff --git a/versioned_docs/version-2.1/sql-manual/sql-functions/scalar-functions/numeric-functions/degrees.md b/versioned_docs/version-2.1/sql-manual/sql-functions/scalar-functions/numeric-functions/degrees.md index d646e503ccb..a9efbe92cce 100644 --- a/versioned_docs/version-2.1/sql-manual/sql-functions/scalar-functions/numeric-functions/degrees.md +++ b/versioned_docs/version-2.1/sql-manual/sql-functions/scalar-functions/numeric-functions/degrees.md @@ -22,36 +22,40 @@ specific language governing permissions and limitations under the License. --> -## degrees +## Description -### description -#### Syntax +Input a double-precision floating-point number and convert it from radians to degrees. -`DOUBLE degrees(DOUBLE x)` -Returns the degree of `x`, converted from radians to degrees. +- When the parameter is NULL, return NULL. -### example +## Syntax +```sql +DEGREES(<a>) ``` -mysql> select degrees(0); -+--------------+ -| degrees(0.0) | -+--------------+ -| 0 | -+--------------+ -mysql> select degrees(2); -+--------------------+ -| degrees(2.0) | -+--------------------+ -| 114.59155902616465 | -+--------------------+ -mysql> select degrees(Pi()); -+---------------+ -| degrees(pi()) | -+---------------+ -| 180 | -+---------------+ + +## Parameters + +| parameter | explain | +| -- | -- | +| `<a>` | The value that needs to be converted from radians to degrees. | + +## Return Value + +The angle of parameter a. + +- When the parameter is NULL, return NULL. + +## Examples + +```sql +select degrees(3.14),degrees(1),degrees(-1),degrees(NULL) ``` -### keywords - DEGREES +```text ++-------------------------------+----------------------------+-----------------------------+---------------+ +| degrees(cast(3.14 as DOUBLE)) | degrees(cast(1 as DOUBLE)) | degrees(cast(-1 as DOUBLE)) | degrees(NULL) | ++-------------------------------+----------------------------+-----------------------------+---------------+ +| 179.9087476710785 | 57.29577951308232 | -57.29577951308232 | NULL | ++-------------------------------+----------------------------+-----------------------------+---------------+ +``` \ No newline at end of file diff --git a/versioned_docs/version-2.1/sql-manual/sql-functions/scalar-functions/numeric-functions/dfloor.md b/versioned_docs/version-2.1/sql-manual/sql-functions/scalar-functions/numeric-functions/dfloor.md deleted file mode 100644 index 7ad992dac15..00000000000 --- a/versioned_docs/version-2.1/sql-manual/sql-functions/scalar-functions/numeric-functions/dfloor.md +++ /dev/null @@ -1,6 +0,0 @@ ---- -{ - "title": "DFLOOR", - "language": "zh-CN" -} ---- diff --git a/versioned_docs/version-2.1/sql-manual/sql-functions/scalar-functions/numeric-functions/dlog10.md b/versioned_docs/version-2.1/sql-manual/sql-functions/scalar-functions/numeric-functions/dlog10.md deleted file mode 100644 index d24692aac13..00000000000 --- a/versioned_docs/version-2.1/sql-manual/sql-functions/scalar-functions/numeric-functions/dlog10.md +++ /dev/null @@ -1,6 +0,0 @@ ---- -{ - "title": "DLOG10", - "language": "zh-CN" -} ---- diff --git a/versioned_docs/version-3.0/sql-manual/sql-functions/scalar-functions/numeric-functions/degrees.md b/versioned_docs/version-3.0/sql-manual/sql-functions/scalar-functions/numeric-functions/degrees.md index d646e503ccb..a9efbe92cce 100644 --- a/versioned_docs/version-3.0/sql-manual/sql-functions/scalar-functions/numeric-functions/degrees.md +++ b/versioned_docs/version-3.0/sql-manual/sql-functions/scalar-functions/numeric-functions/degrees.md @@ -22,36 +22,40 @@ specific language governing permissions and limitations under the License. --> -## degrees +## Description -### description -#### Syntax +Input a double-precision floating-point number and convert it from radians to degrees. -`DOUBLE degrees(DOUBLE x)` -Returns the degree of `x`, converted from radians to degrees. +- When the parameter is NULL, return NULL. -### example +## Syntax +```sql +DEGREES(<a>) ``` -mysql> select degrees(0); -+--------------+ -| degrees(0.0) | -+--------------+ -| 0 | -+--------------+ -mysql> select degrees(2); -+--------------------+ -| degrees(2.0) | -+--------------------+ -| 114.59155902616465 | -+--------------------+ -mysql> select degrees(Pi()); -+---------------+ -| degrees(pi()) | -+---------------+ -| 180 | -+---------------+ + +## Parameters + +| parameter | explain | +| -- | -- | +| `<a>` | The value that needs to be converted from radians to degrees. | + +## Return Value + +The angle of parameter a. + +- When the parameter is NULL, return NULL. + +## Examples + +```sql +select degrees(3.14),degrees(1),degrees(-1),degrees(NULL) ``` -### keywords - DEGREES +```text ++-------------------------------+----------------------------+-----------------------------+---------------+ +| degrees(cast(3.14 as DOUBLE)) | degrees(cast(1 as DOUBLE)) | degrees(cast(-1 as DOUBLE)) | degrees(NULL) | ++-------------------------------+----------------------------+-----------------------------+---------------+ +| 179.9087476710785 | 57.29577951308232 | -57.29577951308232 | NULL | ++-------------------------------+----------------------------+-----------------------------+---------------+ +``` \ No newline at end of file diff --git a/versioned_docs/version-3.0/sql-manual/sql-functions/scalar-functions/numeric-functions/dfloor.md b/versioned_docs/version-3.0/sql-manual/sql-functions/scalar-functions/numeric-functions/dfloor.md deleted file mode 100644 index 7ad992dac15..00000000000 --- a/versioned_docs/version-3.0/sql-manual/sql-functions/scalar-functions/numeric-functions/dfloor.md +++ /dev/null @@ -1,6 +0,0 @@ ---- -{ - "title": "DFLOOR", - "language": "zh-CN" -} ---- diff --git a/versioned_docs/version-3.0/sql-manual/sql-functions/scalar-functions/numeric-functions/dlog10.md b/versioned_docs/version-3.0/sql-manual/sql-functions/scalar-functions/numeric-functions/dlog10.md deleted file mode 100644 index d24692aac13..00000000000 --- a/versioned_docs/version-3.0/sql-manual/sql-functions/scalar-functions/numeric-functions/dlog10.md +++ /dev/null @@ -1,6 +0,0 @@ ---- -{ - "title": "DLOG10", - "language": "zh-CN" -} ---- diff --git a/versioned_sidebars/version-2.1-sidebars.json b/versioned_sidebars/version-2.1-sidebars.json index b14fb35dde3..a6207f5d64b 100644 --- a/versioned_sidebars/version-2.1-sidebars.json +++ b/versioned_sidebars/version-2.1-sidebars.json @@ -907,8 +907,6 @@ "sql-manual/sql-functions/scalar-functions/numeric-functions/cosh", "sql-manual/sql-functions/scalar-functions/numeric-functions/conv", "sql-manual/sql-functions/scalar-functions/numeric-functions/degrees", - "sql-manual/sql-functions/scalar-functions/numeric-functions/dfloor", - "sql-manual/sql-functions/scalar-functions/numeric-functions/dlog10", "sql-manual/sql-functions/scalar-functions/numeric-functions/dround", "sql-manual/sql-functions/scalar-functions/numeric-functions/dsqrt", "sql-manual/sql-functions/scalar-functions/numeric-functions/e", diff --git a/versioned_sidebars/version-3.0-sidebars.json b/versioned_sidebars/version-3.0-sidebars.json index a780e3517ad..384e0c8d0e0 100644 --- a/versioned_sidebars/version-3.0-sidebars.json +++ b/versioned_sidebars/version-3.0-sidebars.json @@ -952,8 +952,6 @@ "sql-manual/sql-functions/scalar-functions/numeric-functions/cosh", "sql-manual/sql-functions/scalar-functions/numeric-functions/conv", "sql-manual/sql-functions/scalar-functions/numeric-functions/degrees", - "sql-manual/sql-functions/scalar-functions/numeric-functions/dfloor", - "sql-manual/sql-functions/scalar-functions/numeric-functions/dlog10", "sql-manual/sql-functions/scalar-functions/numeric-functions/dround", "sql-manual/sql-functions/scalar-functions/numeric-functions/dsqrt", "sql-manual/sql-functions/scalar-functions/numeric-functions/e", --------------------------------------------------------------------- To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org