This is an automated email from the ASF dual-hosted git repository.
morningman 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 a43d567a54a [doc] hour/minute/second functions support time as an
argument. (#1148)
a43d567a54a is described below
commit a43d567a54a2155b6e892b7d532089eb5396d163
Author: Mryange <59914473+mrya...@users.noreply.github.com>
AuthorDate: Thu Oct 31 11:08:30 2024 +0800
[doc] hour/minute/second functions support time as an argument. (#1148)
# Versions
https://github.com/apache/doris/pull/41008
- [x] dev
- [x] 3.0
- [x] 2.1
- [ ] 2.0
# Languages
- [x] Chinese
- [x] English
---
.../sql-functions/date-time-functions/hour.md | 25 ++++++++++++-------
.../sql-functions/date-time-functions/minute.md | 15 ++++++------
.../sql-functions/date-time-functions/second.md | 17 +++++++------
.../sql-functions/date-time-functions/hour.md | 26 +++++++++++++-------
.../sql-functions/date-time-functions/minute.md | 19 ++++++++-------
.../sql-functions/date-time-functions/second.md | 19 ++++++++-------
.../sql-functions/date-time-functions/hour.md | 28 +++++++++++++++-------
.../sql-functions/date-time-functions/minute.md | 18 +++++++-------
.../sql-functions/date-time-functions/second.md | 17 +++++++------
.../sql-functions/date-time-functions/hour.md | 25 ++++++++++++-------
.../sql-functions/date-time-functions/minute.md | 17 +++++++------
.../sql-functions/date-time-functions/second.md | 18 +++++++-------
.../sql-functions/date-time-functions/hour.md | 26 +++++++++++++-------
.../sql-functions/date-time-functions/minute.md | 17 ++++++-------
.../sql-functions/date-time-functions/second.md | 17 ++++++-------
.../sql-functions/date-time-functions/hour.md | 27 ++++++++++++++-------
.../sql-functions/date-time-functions/minute.md | 16 ++++++-------
.../sql-functions/date-time-functions/second.md | 17 ++++++-------
18 files changed, 207 insertions(+), 157 deletions(-)
diff --git a/docs/sql-manual/sql-functions/date-time-functions/hour.md
b/docs/sql-manual/sql-functions/date-time-functions/hour.md
index afe164c7cbe..d5e9be130ec 100644
--- a/docs/sql-manual/sql-functions/date-time-functions/hour.md
+++ b/docs/sql-manual/sql-functions/date-time-functions/hour.md
@@ -24,25 +24,32 @@ specific language governing permissions and limitations
under the License.
-->
-## hour
-### description
-#### Syntax
+## Description
-`INT HOUR(DATETIME date)`
+Retrieves the hour information from a date.
+
+The parameter can be of type Date, DateTime, or Time.
-Returns hour information in the time type, ranging from 0,23
+When the parameter is of type Date or DateTime, the return value ranges from 0
to 23. When the parameter is of type Time, the return value can exceed 24.
-The parameter is Date or Datetime type
+## Syntax
+`INT HOUR(DATETIME date)`
-### example
+## Example
-```
+```sql
mysql> select hour('2018-12-31 23:59:59');
+-----------------------------+
| hour('2018-12-31 23:59:59') |
+-----------------------------+
| 23 |
+-----------------------------+
+mysql> select cast(4562632 as time),hour(cast(4562632 as time)),
minute(cast(4562632 as time)),second(cast(4562632 as time));
++-----------------------+-----------------------------+-------------------------------+-------------------------------+
+| cast(4562632 as TIME) | hour(cast(4562632 as TIME)) | minute(cast(4562632 as
TIME)) | second(cast(4562632 as TIME)) |
++-----------------------+-----------------------------+-------------------------------+-------------------------------+
+| 456:26:32 | 456 |
26 | 32 |
++-----------------------+-----------------------------+-------------------------------+-------------------------------+
```
-### keywords
+## Keywords
HOUR
diff --git a/docs/sql-manual/sql-functions/date-time-functions/minute.md
b/docs/sql-manual/sql-functions/date-time-functions/minute.md
index 5af9edccce4..cfa348e7399 100644
--- a/docs/sql-manual/sql-functions/date-time-functions/minute.md
+++ b/docs/sql-manual/sql-functions/date-time-functions/minute.md
@@ -24,19 +24,18 @@ specific language governing permissions and limitations
under the License.
-->
-## minute
-### description
-#### Syntax
-`INT MINUTE(DATETIME date)`
+## Description
Returns minute information in the time type, ranging from 0,59
-The parameter is Date or Datetime type
+The parameter is Date or Datetime or Time type
+## Syntax
+`INT MINUTE(DATETIME date)`
-### example
+## Example
-```
+```sql
mysql> select minute('2018-12-31 23:59:59');
+-----------------------------+
| minute('2018-12-31 23:59:59') |
@@ -44,5 +43,5 @@ mysql> select minute('2018-12-31 23:59:59');
| 59 |
+-----------------------------+
```
-### keywords
+## Keywords
MINUTE
diff --git a/docs/sql-manual/sql-functions/date-time-functions/second.md
b/docs/sql-manual/sql-functions/date-time-functions/second.md
index c33853685ec..cbe73597cfe 100644
--- a/docs/sql-manual/sql-functions/date-time-functions/second.md
+++ b/docs/sql-manual/sql-functions/date-time-functions/second.md
@@ -24,19 +24,18 @@ specific language governing permissions and limitations
under the License.
-->
-## second
-### description
-#### Syntax
-
-`INT SECOND(DATETIME date)`
+## Description
Returns second information in the time type, ranging from 0,59
-The parameter is Date or Datetime type
+The parameter is Date or Datetime or Time type
-### example
+## Syntax
+`INT SECOND(DATETIME date)`
-```
+## Example
+
+```sql
mysql> select second('2018-12-31 23:59:59');
+-----------------------------+
| second('2018-12-31 23:59:59') |
@@ -44,5 +43,5 @@ mysql> select second('2018-12-31 23:59:59');
| 59 |
+-----------------------------+
```
-### keywords
+## Keywords
SECOND
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/date-time-functions/hour.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/date-time-functions/hour.md
index d156dc38f37..40be0e1c0b0 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/date-time-functions/hour.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/date-time-functions/hour.md
@@ -24,26 +24,34 @@ specific language governing permissions and limitations
under the License.
-->
-## hour
-### description
-#### Syntax
+## Description
-`INT HOUR(DATETIME date)`
+获得日期中的小时的信息。
-获得日期中的小时的信息，返回值范围从0-23。
+参数为 Date 或者 Datetime，Time 类型
-参数为Date或者Datetime类型
+当参数为 Date 或者 Datetime，返回值范围从 0-23。当参数为 Time，返回值可以大于 24
-### example
+## Syntax
-```
+`INT HOUR(DATETIME date)`
+## Example
+
+```sql
mysql> select hour('2018-12-31 23:59:59');
+-----------------------------+
| hour('2018-12-31 23:59:59') |
+-----------------------------+
| 23 |
+-----------------------------+
+
+mysql> select cast(4562632 as time),hour(cast(4562632 as time)),
minute(cast(4562632 as time)),second(cast(4562632 as time));
++-----------------------+-----------------------------+-------------------------------+-------------------------------+
+| cast(4562632 as TIME) | hour(cast(4562632 as TIME)) | minute(cast(4562632 as
TIME)) | second(cast(4562632 as TIME)) |
++-----------------------+-----------------------------+-------------------------------+-------------------------------+
+| 456:26:32 | 456 |
26 | 32 |
++-----------------------+-----------------------------+-------------------------------+-------------------------------+
```
-### keywords
+## Keywords
HOUR
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/date-time-functions/minute.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/date-time-functions/minute.md
index 8c4492c6591..0803c1f016a 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/date-time-functions/minute.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/date-time-functions/minute.md
@@ -24,20 +24,21 @@ specific language governing permissions and limitations
under the License.
-->
-## minute
-### description
-#### Syntax
-`INT MINUTE(DATETIME date)`
+## Description
-获得日期中的分钟的信息，返回值范围从0-59。
+获得日期中的分钟的信息，返回值范围从 0-59。
-参数为Date或者Datetime类型
+参数为 Date 或者 Datetime，Time 类型
-### example
+## Syntax
-```
+`INT MINUTE(DATETIME date)`
+
+## Example
+
+```sql
mysql> select minute('2018-12-31 23:59:59');
+-----------------------------+
| minute('2018-12-31 23:59:59') |
@@ -45,5 +46,5 @@ mysql> select minute('2018-12-31 23:59:59');
| 59 |
+-----------------------------+
```
-### keywords
+## Keywords
MINUTE
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/date-time-functions/second.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/date-time-functions/second.md
index 64a061a1741..530fa4d6694 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/date-time-functions/second.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/date-time-functions/second.md
@@ -24,20 +24,21 @@ specific language governing permissions and limitations
under the License.
-->
-## second
-### description
-#### Syntax
+## Description
-`INT SECOND(DATETIME date)`
-获得日期中的秒的信息，返回值范围从0-59。
+获得日期中的秒的信息，返回值范围从 0-59。
-参数为Date或者Datetime类型
+参数为 Date 或者 Datetime，Time 类型
-### example
+## Syntax
-```
+`INT SECOND(DATETIME date)`
+
+## Example
+
+```sql
mysql> select second('2018-12-31 23:59:59');
+-----------------------------+
| second('2018-12-31 23:59:59') |
@@ -45,5 +46,5 @@ mysql> select second('2018-12-31 23:59:59');
| 59 |
+-----------------------------+
```
-### keywords
+## Keywords
SECOND
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/sql-functions/date-time-functions/hour.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/sql-functions/date-time-functions/hour.md
index d156dc38f37..eb5f923e1a3 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/sql-functions/date-time-functions/hour.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/sql-functions/date-time-functions/hour.md
@@ -24,26 +24,36 @@ specific language governing permissions and limitations
under the License.
-->
-## hour
-### description
-#### Syntax
+## Description
-`INT HOUR(DATETIME date)`
-获得日期中的小时的信息，返回值范围从0-23。
-参数为Date或者Datetime类型
+获得日期中的小时的信息。
-### example
+参数为 Date 或者 Datetime，Time 类型
-```
+当参数为 Date 或者 Datetime，返回值范围从 0-23。当参数为 Time，返回值可以大于 24
+
+## Syntax
+
+`INT HOUR(DATETIME date)`
+
+## Example
+
+```sql
mysql> select hour('2018-12-31 23:59:59');
+-----------------------------+
| hour('2018-12-31 23:59:59') |
+-----------------------------+
| 23 |
+-----------------------------+
+mysql> select cast(4562632 as time),hour(cast(4562632 as time)),
minute(cast(4562632 as time)),second(cast(4562632 as time));
++-----------------------+-----------------------------+-------------------------------+-------------------------------+
+| cast(4562632 as TIME) | hour(cast(4562632 as TIME)) | minute(cast(4562632 as
TIME)) | second(cast(4562632 as TIME)) |
++-----------------------+-----------------------------+-------------------------------+-------------------------------+
+| 456:26:32 | 456 |
26 | 32 |
++-----------------------+-----------------------------+-------------------------------+-------------------------------+
```
-### keywords
+## Keywords
HOUR
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/sql-functions/date-time-functions/minute.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/sql-functions/date-time-functions/minute.md
index 8c4492c6591..8a4ee6461ab 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/sql-functions/date-time-functions/minute.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/sql-functions/date-time-functions/minute.md
@@ -24,20 +24,20 @@ specific language governing permissions and limitations
under the License.
-->
-## minute
-### description
-#### Syntax
+## Description
-`INT MINUTE(DATETIME date)`
+获得日期中的分钟的信息，返回值范围从 0-59。
+
+参数为 Date 或者 Datetime，Time 类型
-获得日期中的分钟的信息，返回值范围从0-59。
+## Syntax
-参数为Date或者Datetime类型
+`INT MINUTE(DATETIME date)`
-### example
+## Example
-```
+```sql
mysql> select minute('2018-12-31 23:59:59');
+-----------------------------+
| minute('2018-12-31 23:59:59') |
@@ -45,5 +45,5 @@ mysql> select minute('2018-12-31 23:59:59');
| 59 |
+-----------------------------+
```
-### keywords
+## Keywords
MINUTE
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/sql-functions/date-time-functions/second.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/sql-functions/date-time-functions/second.md
index 64a061a1741..266d1909ac8 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/sql-functions/date-time-functions/second.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/sql-functions/date-time-functions/second.md
@@ -24,20 +24,19 @@ specific language governing permissions and limitations
under the License.
-->
-## second
-### description
-#### Syntax
+## Description
-`INT SECOND(DATETIME date)`
+获得日期中的秒的信息，返回值范围从 0-59。
-获得日期中的秒的信息，返回值范围从0-59。
+参数为 Date 或者 Datetime，Time 类型
-参数为Date或者Datetime类型
+## Syntax
+`INT SECOND(DATETIME date)`
-### example
+## Example
-```
+```sql
mysql> select second('2018-12-31 23:59:59');
+-----------------------------+
| second('2018-12-31 23:59:59') |
@@ -45,5 +44,5 @@ mysql> select second('2018-12-31 23:59:59');
| 59 |
+-----------------------------+
```
-### keywords
+## Keywords
SECOND
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/sql-manual/sql-functions/date-time-functions/hour.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/sql-manual/sql-functions/date-time-functions/hour.md
index d156dc38f37..6c5a318454b 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/sql-manual/sql-functions/date-time-functions/hour.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/sql-manual/sql-functions/date-time-functions/hour.md
@@ -24,26 +24,33 @@ specific language governing permissions and limitations
under the License.
-->
-## hour
-### description
-#### Syntax
+## Description
-`INT HOUR(DATETIME date)`
+获得日期中的小时的信息。
+
+参数为 Date 或者 Datetime，Time 类型
-获得日期中的小时的信息，返回值范围从0-23。
+当参数为 Date 或者 Datetime，返回值范围从 0-23。当参数为 Time，返回值可以大于 24
-参数为Date或者Datetime类型
+## Syntax
+`INT HOUR(DATETIME date)`
-### example
+## Example
-```
+```sql
mysql> select hour('2018-12-31 23:59:59');
+-----------------------------+
| hour('2018-12-31 23:59:59') |
+-----------------------------+
| 23 |
+-----------------------------+
+mysql> select cast(4562632 as time),hour(cast(4562632 as time)),
minute(cast(4562632 as time)),second(cast(4562632 as time));
++-----------------------+-----------------------------+-------------------------------+-------------------------------+
+| cast(4562632 as TIME) | hour(cast(4562632 as TIME)) | minute(cast(4562632 as
TIME)) | second(cast(4562632 as TIME)) |
++-----------------------+-----------------------------+-------------------------------+-------------------------------+
+| 456:26:32 | 456 |
26 | 32 |
++-----------------------+-----------------------------+-------------------------------+-------------------------------+
```
-### keywords
+## Keywords
HOUR
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/sql-manual/sql-functions/date-time-functions/minute.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/sql-manual/sql-functions/date-time-functions/minute.md
index 8c4492c6591..ead7a7e5026 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/sql-manual/sql-functions/date-time-functions/minute.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/sql-manual/sql-functions/date-time-functions/minute.md
@@ -24,20 +24,19 @@ specific language governing permissions and limitations
under the License.
-->
-## minute
-### description
-#### Syntax
+## Description
-`INT MINUTE(DATETIME date)`
+获得日期中的分钟的信息，返回值范围从 0-59。
-获得日期中的分钟的信息，返回值范围从0-59。
+参数为 Date 或者 Datetime，Time 类型
-参数为Date或者Datetime类型
+## Syntax
+`INT MINUTE(DATETIME date)`
-### example
+## Example
-```
+```sql
mysql> select minute('2018-12-31 23:59:59');
+-----------------------------+
| minute('2018-12-31 23:59:59') |
@@ -45,5 +44,5 @@ mysql> select minute('2018-12-31 23:59:59');
| 59 |
+-----------------------------+
```
-### keywords
+## Keywords
MINUTE
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/sql-manual/sql-functions/date-time-functions/second.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/sql-manual/sql-functions/date-time-functions/second.md
index 64a061a1741..5e4b4d1053f 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/sql-manual/sql-functions/date-time-functions/second.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/sql-manual/sql-functions/date-time-functions/second.md
@@ -24,20 +24,20 @@ specific language governing permissions and limitations
under the License.
-->
-## second
-### description
-#### Syntax
+## Description
-`INT SECOND(DATETIME date)`
+获得日期中的秒的信息，返回值范围从 0-59。
+
+参数为 Date 或者 Datetime，Time 类型
-获得日期中的秒的信息，返回值范围从0-59。
+## Syntax
-参数为Date或者Datetime类型
+`INT SECOND(DATETIME date)`
-### example
+## Example
-```
+```sql
mysql> select second('2018-12-31 23:59:59');
+-----------------------------+
| second('2018-12-31 23:59:59') |
@@ -45,5 +45,5 @@ mysql> select second('2018-12-31 23:59:59');
| 59 |
+-----------------------------+
```
-### keywords
+## Keywords
SECOND
diff --git
a/versioned_docs/version-2.1/sql-manual/sql-functions/date-time-functions/hour.md
b/versioned_docs/version-2.1/sql-manual/sql-functions/date-time-functions/hour.md
index afe164c7cbe..b321ee2e753 100644
---
a/versioned_docs/version-2.1/sql-manual/sql-functions/date-time-functions/hour.md
+++
b/versioned_docs/version-2.1/sql-manual/sql-functions/date-time-functions/hour.md
@@ -24,25 +24,33 @@ specific language governing permissions and limitations
under the License.
-->
-## hour
-### description
-#### Syntax
+## Description
-`INT HOUR(DATETIME date)`
-Returns hour information in the time type, ranging from 0,23
+Retrieves the hour information from a date.
-The parameter is Date or Datetime type
+The parameter can be of type Date, DateTime, or Time.
-### example
+When the parameter is of type Date or DateTime, the return value ranges from 0
to 23. When the parameter is of type Time, the return value can exceed 24.
-```
+## Syntax
+`INT HOUR(DATETIME date)`
+
+## Example
+
+```sql
mysql> select hour('2018-12-31 23:59:59');
+-----------------------------+
| hour('2018-12-31 23:59:59') |
+-----------------------------+
| 23 |
+-----------------------------+
+mysql> select cast(4562632 as time),hour(cast(4562632 as time)),
minute(cast(4562632 as time)),second(cast(4562632 as time));
++-----------------------+-----------------------------+-------------------------------+-------------------------------+
+| cast(4562632 as TIME) | hour(cast(4562632 as TIME)) | minute(cast(4562632 as
TIME)) | second(cast(4562632 as TIME)) |
++-----------------------+-----------------------------+-------------------------------+-------------------------------+
+| 456:26:32 | 456 |
26 | 32 |
++-----------------------+-----------------------------+-------------------------------+-------------------------------+
```
-### keywords
+## Keywords
HOUR
diff --git
a/versioned_docs/version-2.1/sql-manual/sql-functions/date-time-functions/minute.md
b/versioned_docs/version-2.1/sql-manual/sql-functions/date-time-functions/minute.md
index 5af9edccce4..1c853b7d996 100644
---
a/versioned_docs/version-2.1/sql-manual/sql-functions/date-time-functions/minute.md
+++
b/versioned_docs/version-2.1/sql-manual/sql-functions/date-time-functions/minute.md
@@ -24,19 +24,20 @@ specific language governing permissions and limitations
under the License.
-->
-## minute
-### description
-#### Syntax
+## Description
-`INT MINUTE(DATETIME date)`
Returns minute information in the time type, ranging from 0,59
-The parameter is Date or Datetime type
+The parameter is Date or Datetime or Time type
-### example
+## Syntax
+`INT MINUTE(DATETIME date)`
-```
+
+## Example
+
+```sql
mysql> select minute('2018-12-31 23:59:59');
+-----------------------------+
| minute('2018-12-31 23:59:59') |
@@ -44,5 +45,5 @@ mysql> select minute('2018-12-31 23:59:59');
| 59 |
+-----------------------------+
```
-### keywords
+## Keywords
MINUTE
diff --git
a/versioned_docs/version-2.1/sql-manual/sql-functions/date-time-functions/second.md
b/versioned_docs/version-2.1/sql-manual/sql-functions/date-time-functions/second.md
index c33853685ec..f64cace3301 100644
---
a/versioned_docs/version-2.1/sql-manual/sql-functions/date-time-functions/second.md
+++
b/versioned_docs/version-2.1/sql-manual/sql-functions/date-time-functions/second.md
@@ -24,19 +24,20 @@ specific language governing permissions and limitations
under the License.
-->
-## second
-### description
-#### Syntax
+## Description
-`INT SECOND(DATETIME date)`
Returns second information in the time type, ranging from 0,59
-The parameter is Date or Datetime type
+The parameter is Date or Datetime or Time type
-### example
-```
+## Syntax
+`INT SECOND(DATETIME date)`
+
+## Example
+
+```sql
mysql> select second('2018-12-31 23:59:59');
+-----------------------------+
| second('2018-12-31 23:59:59') |
@@ -44,5 +45,5 @@ mysql> select second('2018-12-31 23:59:59');
| 59 |
+-----------------------------+
```
-### keywords
+## Keywords
SECOND
diff --git
a/versioned_docs/version-3.0/sql-manual/sql-functions/date-time-functions/hour.md
b/versioned_docs/version-3.0/sql-manual/sql-functions/date-time-functions/hour.md
index afe164c7cbe..d1bf2685bc1 100644
---
a/versioned_docs/version-3.0/sql-manual/sql-functions/date-time-functions/hour.md
+++
b/versioned_docs/version-3.0/sql-manual/sql-functions/date-time-functions/hour.md
@@ -24,25 +24,34 @@ specific language governing permissions and limitations
under the License.
-->
-## hour
-### description
-#### Syntax
+## Description
-`INT HOUR(DATETIME date)`
-Returns hour information in the time type, ranging from 0,23
+Retrieves the hour information from a date.
-The parameter is Date or Datetime type
+The parameter can be of type Date, DateTime, or Time.
-### example
+When the parameter is of type Date or DateTime, the return value ranges from 0
to 23. When the parameter is of type Time, the return value can exceed 24.
-```
+## Syntax
+
+`INT HOUR(DATETIME date)`
+
+## Example
+
+```sql
mysql> select hour('2018-12-31 23:59:59');
+-----------------------------+
| hour('2018-12-31 23:59:59') |
+-----------------------------+
| 23 |
+-----------------------------+
+mysql> select cast(4562632 as time),hour(cast(4562632 as time)),
minute(cast(4562632 as time)),second(cast(4562632 as time));
++-----------------------+-----------------------------+-------------------------------+-------------------------------+
+| cast(4562632 as TIME) | hour(cast(4562632 as TIME)) | minute(cast(4562632 as
TIME)) | second(cast(4562632 as TIME)) |
++-----------------------+-----------------------------+-------------------------------+-------------------------------+
+| 456:26:32 | 456 |
26 | 32 |
++-----------------------+-----------------------------+-------------------------------+-------------------------------+
```
-### keywords
+## Keywords
HOUR
diff --git
a/versioned_docs/version-3.0/sql-manual/sql-functions/date-time-functions/minute.md
b/versioned_docs/version-3.0/sql-manual/sql-functions/date-time-functions/minute.md
index 5af9edccce4..fedfde0bffa 100644
---
a/versioned_docs/version-3.0/sql-manual/sql-functions/date-time-functions/minute.md
+++
b/versioned_docs/version-3.0/sql-manual/sql-functions/date-time-functions/minute.md
@@ -24,19 +24,19 @@ specific language governing permissions and limitations
under the License.
-->
-## minute
-### description
-#### Syntax
+## Description
-`INT MINUTE(DATETIME date)`
Returns minute information in the time type, ranging from 0,59
-The parameter is Date or Datetime type
+The parameter is Date or Datetime or Time type
+
+## Syntax
+`INT MINUTE(DATETIME date)`
-### example
+## Example
-```
+```sql
mysql> select minute('2018-12-31 23:59:59');
+-----------------------------+
| minute('2018-12-31 23:59:59') |
@@ -44,5 +44,5 @@ mysql> select minute('2018-12-31 23:59:59');
| 59 |
+-----------------------------+
```
-### keywords
+## Keywords
MINUTE
diff --git
a/versioned_docs/version-3.0/sql-manual/sql-functions/date-time-functions/second.md
b/versioned_docs/version-3.0/sql-manual/sql-functions/date-time-functions/second.md
index c33853685ec..6ae78fa666a 100644
---
a/versioned_docs/version-3.0/sql-manual/sql-functions/date-time-functions/second.md
+++
b/versioned_docs/version-3.0/sql-manual/sql-functions/date-time-functions/second.md
@@ -24,19 +24,20 @@ specific language governing permissions and limitations
under the License.
-->
-## second
-### description
-#### Syntax
+## Description
-`INT SECOND(DATETIME date)`
Returns second information in the time type, ranging from 0,59
-The parameter is Date or Datetime type
+The parameter is Date or Datetime or Time type
-### example
+## Syntax
-```
+`INT SECOND(DATETIME date)`
+
+## Example
+
+```sql
mysql> select second('2018-12-31 23:59:59');
+-----------------------------+
| second('2018-12-31 23:59:59') |
@@ -44,5 +45,5 @@ mysql> select second('2018-12-31 23:59:59');
| 59 |
+-----------------------------+
```
-### keywords
+## Keywords
SECOND
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org
For additional commands, e-mail: commits-h...@doris.apache.org
