table alignment in conditional and date-time function docs (#3709)

morningman Wed, 20 May 2026 09:25:52 -0700

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 6095bd685e6 [fix] correct typos / mislabeled examples / table 
alignment in conditional and date-time function docs (#3709)
6095bd685e6 is described below

commit 6095bd685e696f3938a96aef38e562d2ddc08ccd
Author: boluor <[email protected]>
AuthorDate: Wed May 20 09:00:04 2026 -0700

    [fix] correct typos / mislabeled examples / table alignment in conditional 
and date-time function docs (#3709)
    
    ## Summary
    
    Fixes 16 small documentation issues across the conditional and date-time
    function references. Each item below is independent.
    
    ### conditional-functions
    
    - **not-null-or-empty.md / null-or-empty.md** — example SQL had an
    embedded `;` inside the SELECT list (`not_null_or_empty("");, ...` and
    `null_or_empty("");, ...`) which makes the statement invalid. The stray
    `;` is removed.
    - **null-or-empty.md** — the Description (both frontmatter and body)
    said the function returns true when the input is *NOT* NULL and *NOT*
    empty (which is the semantics of `not_null_or_empty`). Inverted the
    wording so it correctly describes `null_or_empty`.
    - **conditional-functions/overview.md** — the short-circuit example's
    result table had a header row one character shorter than its rulers
    (rulers were 73 dashes, header was 72). Header and rulers are now the
    same width.
    
    ### date-time-functions
    
    - **convert-tz.md** — result-table header showed `CAST(... AS DATEV2)`
    while the query used `AS DATE`. Header aligned with the query.
    - **date-sub.md** — a stray closing ``` fence sat at the very end of the
    file with no matching opener. Removed.
    - **date-trunc.md** — the parameters table labelled the first argument
    `\`<date_or_time_part>\`` while the Syntax used `\`<datetime>\``.
    Unified on `\`<datetime>\`` to match the syntax (and the convention in
    sibling docs).
    - **millisecond-timestamp.md** — the 1960-01-01 example showed
    `-315619200000000` (a microsecond magnitude) for a function that returns
    milliseconds. Corrected to `-315619200000`.
    - **maketime.md** — the result table included an `id` column that the
    query never selects. Removed the `id` column from the result table
    (header, separator, and all data rows).
    - **microsecond-timestamp.md** — the 1960-01-01 result-table header row
    was 1 character shorter than its rulers. Added a trailing space so the
    table renders square.
    - **from-iso8601-date.md** — inline comments mis-spelled the
    date-pattern notation as `YYY-MMM`; corrected to `YYYY-Www` to match the
    notation used elsewhere in the doc.
    - **minute-ceil.md / minute-floor.md** (and a few sibling docs that had
    the same leak: `hour-ceil.md`, `second-ceil.md`, `second-floor.md`) — a
    Chinese link label `[timestamptz的转换]` appeared inside English docs;
    changed to `[timestamptz conversion]`.
    - **minute-floor.md** — a result-table value used `.000` while sibling
    docs use `.000000`. Aligned to `.000000`.
    - **minute-floor.md** — a mixed-case `MINUTE_floor(...)` invocation;
    corrected to `MINUTE_FLOOR(...)`.
    - **month-floor.md** — the "Period non-positive" example invoked
    `MINUTE_FLOOR` and the error message echoed `minute_floor` (copy-paste
    from minute-floor.md). Corrected to `MONTH_FLOOR` / `month_floor`.
    - **period-add.md** — the Syntax line was `PERIOD_ADD(\`<period>\`,
    \`month\`)` — second arg missing the angle brackets. Corrected to
    `\`<month>\``.
    
    ## Test plan
    
    - [ ] CI doc build passes
    - [ ] Spot-check the affected pages render correctly (conditional
    examples, the short-circuit result table in `overview.md`, `convert-tz`
    result, `date-sub` end-of-file, `date-trunc` params, the
    `millisecond-timestamp` 1960 example value, `maketime` result table,
    `microsecond-timestamp` 1960 header, ISO-8601 comments,
    minute/hour/second/month `_floor`/`_ceil` examples and link labels,
    `period-add` syntax)
---
 .../conditional-functions/not-null-or-empty.md     |  2 +-
 .../conditional-functions/null-or-empty.md         |  6 ++---
 .../conditional-functions/overview.md              |  8 +++---
 .../date-time-functions/convert-tz.md              |  2 +-
 .../date-time-functions/date-sub.md                |  1 -
 .../date-time-functions/date-trunc.md              |  2 +-
 .../date-time-functions/from-iso8601-date.md       |  4 +--
 .../date-time-functions/hour-ceil.md               |  2 +-
 .../date-time-functions/maketime.md                | 30 +++++++++++-----------
 .../date-time-functions/microsecond-timestamp.md   |  2 +-
 .../date-time-functions/millisecond-timestamp.md   |  2 +-
 .../date-time-functions/minute-ceil.md             |  2 +-
 .../date-time-functions/minute-floor.md            |  6 ++---
 .../date-time-functions/month-floor.md             |  4 +--
 .../date-time-functions/period-add.md              |  2 +-
 .../conditional-functions/overview.md              |  8 +++---
 .../date-time-functions/convert-tz.md              |  2 +-
 .../date-time-functions/date-trunc.md              |  4 +--
 .../date-time-functions/from-iso8601-date.md       |  4 +--
 .../date-time-functions/maketime.md                | 30 +++++++++++-----------
 .../date-time-functions/millisecond-timestamp.md   |  2 +-
 .../date-time-functions/minute-floor.md            |  4 +--
 .../date-time-functions/period-add.md              |  2 +-
 .../conditional-functions/overview.md              |  8 +++---
 .../date-time-functions/convert-tz.md              |  2 +-
 .../date-time-functions/date-trunc.md              |  4 +--
 .../date-time-functions/from-iso8601-date.md       |  4 +--
 .../date-time-functions/maketime.md                | 30 +++++++++++-----------
 .../date-time-functions/millisecond-timestamp.md   |  2 +-
 .../date-time-functions/minute-floor.md            |  4 +--
 .../date-time-functions/period-add.md              |  2 +-
 .../conditional-functions/not-null-or-empty.md     |  2 +-
 .../conditional-functions/null-or-empty.md         |  6 ++---
 .../conditional-functions/overview.md              |  8 +++---
 .../date-time-functions/convert-tz.md              |  2 +-
 .../date-time-functions/date-sub.md                |  1 -
 .../date-time-functions/date-trunc.md              |  2 +-
 .../date-time-functions/from-iso8601-date.md       |  4 +--
 .../date-time-functions/hour-ceil.md               |  2 +-
 .../date-time-functions/maketime.md                | 30 +++++++++++-----------
 .../date-time-functions/microsecond-timestamp.md   |  2 +-
 .../date-time-functions/millisecond-timestamp.md   |  2 +-
 .../date-time-functions/minute-ceil.md             |  2 +-
 .../date-time-functions/minute-floor.md            |  6 ++---
 .../date-time-functions/month-floor.md             |  4 +--
 .../date-time-functions/period-add.md              |  2 +-
 46 files changed, 130 insertions(+), 132 deletions(-)

diff --git 
a/docs/sql-manual/sql-functions/scalar-functions/conditional-functions/not-null-or-empty.md
 
b/docs/sql-manual/sql-functions/scalar-functions/conditional-functions/not-null-or-empty.md
index 07ad7724c65..e470a3fff24 100644
--- 
a/docs/sql-manual/sql-functions/scalar-functions/conditional-functions/not-null-or-empty.md
+++ 
b/docs/sql-manual/sql-functions/scalar-functions/conditional-functions/not-null-or-empty.md
@@ -25,7 +25,7 @@ Returns false if the string is an empty string or NULL; 
otherwise, returns true.
 ## Examples
 1. Example 1
     ```sql
-    select not_null_or_empty(null), not_null_or_empty("");, 
not_null_or_empty(" ");
+    select not_null_or_empty(null), not_null_or_empty(""), not_null_or_empty(" 
");
     ```
     ```text
     
+-------------------------+-----------------------+------------------------+
diff --git 
a/docs/sql-manual/sql-functions/scalar-functions/conditional-functions/null-or-empty.md
 
b/docs/sql-manual/sql-functions/scalar-functions/conditional-functions/null-or-empty.md
index c570b484e39..88b8788aeb3 100644
--- 
a/docs/sql-manual/sql-functions/scalar-functions/conditional-functions/null-or-empty.md
+++ 
b/docs/sql-manual/sql-functions/scalar-functions/conditional-functions/null-or-empty.md
@@ -2,13 +2,13 @@
 {
     "title": "NULL_OR_EMPTY",
     "language": "en",
-    "description": "The nullorempty function is used to determine whether the 
given value is not NULL and not empty. If the input value is neither NULL nor 
empty,"
+    "description": "The nullorempty function is used to determine whether the 
given value is NULL or empty. If the input value is NULL or empty,"
 }
 ---
 
 ## Description
 
-The `null_or_empty` function is used to determine whether the given value is 
not NULL and not empty. If the input value is neither NULL nor empty, it 
returns true; otherwise, it returns false.
+The `null_or_empty` function is used to determine whether the given value is 
NULL or empty. If the input value is NULL or empty, it returns true; otherwise, 
it returns false.
 
 ## Syntax
 
@@ -25,7 +25,7 @@ Returns true if the string is an empty string or NULL; 
otherwise, returns false.
 ## Examples
 1. Example 1
     ```sql
-    select null_or_empty(null), null_or_empty("");, null_or_empty(" ");
+    select null_or_empty(null), null_or_empty(""), null_or_empty(" ");
     ```
     ```text
     +---------------------+-------------------+--------------------+
diff --git 
a/docs/sql-manual/sql-functions/scalar-functions/conditional-functions/overview.md
 
b/docs/sql-manual/sql-functions/scalar-functions/conditional-functions/overview.md
index 4f24fe0458f..3ab0b5cad35 100644
--- 
a/docs/sql-manual/sql-functions/scalar-functions/conditional-functions/overview.md
+++ 
b/docs/sql-manual/sql-functions/scalar-functions/conditional-functions/overview.md
@@ -52,11 +52,11 @@ mysql> select count(
     ->       cast(number as tinyint), 
     ->       cast(number as String))
     ->   ) from numbers("number" = "300");
-+-------------------------------------------------------------------------+
-| count(if(number < 128, cast(number as tinyint), cast(number as String)))|
-+-------------------------------------------------------------------------+
++--------------------------------------------------------------------------+
+| count(if(number < 128, cast(number as tinyint), cast(number as String))) |
++--------------------------------------------------------------------------+
 |                                                                      300 |
-+-------------------------------------------------------------------------+
++--------------------------------------------------------------------------+
 ```
 
 With short-circuit evaluation enabled, functions like `if`, `ifnull`, `case`, 
and `coalesce` can avoid unnecessary computations in many scenarios, thus 
preventing errors and improving performance.
diff --git 
a/docs/sql-manual/sql-functions/scalar-functions/date-time-functions/convert-tz.md
 
b/docs/sql-manual/sql-functions/scalar-functions/date-time-functions/convert-tz.md
index 990d4d1b0d2..ed328d9253f 100644
--- 
a/docs/sql-manual/sql-functions/scalar-functions/date-time-functions/convert-tz.md
+++ 
b/docs/sql-manual/sql-functions/scalar-functions/date-time-functions/convert-tz.md
@@ -62,7 +62,7 @@ mysql> select CONVERT_TZ(CAST('2019-08-01 13:21:03' AS 
DATETIME), '+08:00', 'Ame
 -- For date type input,return datetime type value, the time part is 
automatically converted to 00:00:00
 mysql> select CONVERT_TZ(CAST('2019-08-01 13:21:03' AS DATE), 'Asia/Shanghai', 
'America/Los_Angeles');
 
+-------------------------------------------------------------------------------------------+
-| CONVERT_TZ(CAST('2019-08-01 13:21:03' AS DATEV2), 'Asia/Shanghai', 
'America/Los_Angeles') |
+| CONVERT_TZ(CAST('2019-08-01 13:21:03' AS DATE), 'Asia/Shanghai', 
'America/Los_Angeles')   |
 
+-------------------------------------------------------------------------------------------+
 | 2019-07-31 09:00:00                                                          
             |
 
+-------------------------------------------------------------------------------------------+
diff --git 
a/docs/sql-manual/sql-functions/scalar-functions/date-time-functions/date-sub.md
 
b/docs/sql-manual/sql-functions/scalar-functions/date-time-functions/date-sub.md
index 0a082611c22..61edc0c5b79 100644
--- 
a/docs/sql-manual/sql-functions/scalar-functions/date-time-functions/date-sub.md
+++ 
b/docs/sql-manual/sql-functions/scalar-functions/date-time-functions/date-sub.md
@@ -181,4 +181,3 @@ ERROR 1105 (HY000): errCode = 2, detailMessage = 
(10.16.10.3)[E-218]Operation da
 select date_sub('9999-01-01', INTERVAL -1 YEAR);
 ERROR 1105 (HY000): errCode = 2, detailMessage = (10.16.10.3)[E-218]Operation 
year_add of 9999-01-01, 1 out of range
 ```
-```
\ No newline at end of file
diff --git 
a/docs/sql-manual/sql-functions/scalar-functions/date-time-functions/date-trunc.md
 
b/docs/sql-manual/sql-functions/scalar-functions/date-time-functions/date-trunc.md
index ba659d94195..b372f61c876 100644
--- 
a/docs/sql-manual/sql-functions/scalar-functions/date-time-functions/date-trunc.md
+++ 
b/docs/sql-manual/sql-functions/scalar-functions/date-time-functions/date-trunc.md
@@ -21,7 +21,7 @@ DATE_TRUNC(<time_unit>, <datetime>)
 
 | Parameter | Description |
 | -- | -- |
-| `<date_or_time_part>` | A valid date expression, supporting datetime or date 
type. For specific formats, please refer to [timestamptz 
conversion](../../../../sql-manual/basic-element/sql-data-types/conversion/timestamptz-conversion),
 [datetime 
conversion](../../../../sql-manual/basic-element/sql-data-types/conversion/datetime-conversion)
 and [date 
conversion](../../../../sql-manual/basic-element/sql-data-types/conversion/date-conversion)
 |
+| `<datetime>` | A valid date expression, supporting datetime or date type. 
For specific formats, please refer to [timestamptz 
conversion](../../../../sql-manual/basic-element/sql-data-types/conversion/timestamptz-conversion),
 [datetime 
conversion](../../../../sql-manual/basic-element/sql-data-types/conversion/datetime-conversion)
 and [date 
conversion](../../../../sql-manual/basic-element/sql-data-types/conversion/date-conversion)
 |
 | `<time_unit>` | The time interval to truncate to. The available values are: 
[`second`,`minute`,`hour`,`day`,`week`,`month`,`quarter`,`year`] |
 
 ## Return Value
diff --git 
a/docs/sql-manual/sql-functions/scalar-functions/date-time-functions/from-iso8601-date.md
 
b/docs/sql-manual/sql-functions/scalar-functions/date-time-functions/from-iso8601-date.md
index 6632dc6bc35..25aa62ccb3b 100644
--- 
a/docs/sql-manual/sql-functions/scalar-functions/date-time-functions/from-iso8601-date.md
+++ 
b/docs/sql-manual/sql-functions/scalar-functions/date-time-functions/from-iso8601-date.md
@@ -65,7 +65,7 @@ select
 | 0000-01-01 | 0000-02-28 | 0000-03-01 | 2024-12-31 |
 +------------+------------+------------+------------+
 
--- Parse "YYY-MMM-D" format (each week starts with Monday), since 0522-01-01 
is Thursday, dates before the first week will return year 0521
+-- Parse "YYYY-Www-D" format (each week starts with Monday), since 0522-01-01 
is Thursday, dates before the first week will return year 0521
 select from_iso8601_date('0522-W01-1') as week_1;
 +------------+
 | week_1     |
@@ -81,7 +81,7 @@ select from_iso8601_date('0522-W01-4') as week_4;
 | 0522-01-01 |
 +------------+
 
----YYY-MMM format, Monday of the first week is in year 521
+---YYYY-Www format, Monday of the first week is in year 521
 select from_iso8601_date('0522-W01') as week_1;
 +------------+
 | week_1     |
diff --git 
a/docs/sql-manual/sql-functions/scalar-functions/date-time-functions/hour-ceil.md
 
b/docs/sql-manual/sql-functions/scalar-functions/date-time-functions/hour-ceil.md
index 4ac77198cae..42afaec7d00 100644
--- 
a/docs/sql-manual/sql-functions/scalar-functions/date-time-functions/hour-ceil.md
+++ 
b/docs/sql-manual/sql-functions/scalar-functions/date-time-functions/hour-ceil.md
@@ -34,7 +34,7 @@ HOUR_CEIL(`<date_or_time_expr>`, `<period>`, `<origin>`)
 
 | Parameter | Description |
 | -- | -- |
-| `<date_or_time_expr>` | A valid date expression that supports 
datetime/date/timestamptz types. Date type will be converted to the start of 
the day at 00:00:00. For specific formats please see 
[timestamptz的转换](../../../../sql-manual/basic-element/sql-data-types/conversion/timestamptz-conversion),
 and for datetime/date formats refer to [datetime 
conversion](../../../../sql-manual/basic-element/sql-data-types/conversion/datetime-conversion)
 and [date conversion](../../../../sql-manual/bas [...]
+| `<date_or_time_expr>` | A valid date expression that supports 
datetime/date/timestamptz types. Date type will be converted to the start of 
the day at 00:00:00. For specific formats please see [timestamptz 
conversion](../../../../sql-manual/basic-element/sql-data-types/conversion/timestamptz-conversion),
 and for datetime/date formats refer to [datetime 
conversion](../../../../sql-manual/basic-element/sql-data-types/conversion/datetime-conversion)
 and [date conversion](../../../../sql-ma [...]
 | `<period>` | Optional parameter that specifies the period length (unit: 
hours), must be a positive integer (such as 1, 3, 5). Default value is 1, 
representing one period every 1 hour |
 | `<origin>` | The starting time origin, supports datetime and date types. If 
not provided, the default is 0001-01-01T00:00:00 |
 
diff --git 
a/docs/sql-manual/sql-functions/scalar-functions/date-time-functions/maketime.md
 
b/docs/sql-manual/sql-functions/scalar-functions/date-time-functions/maketime.md
index 019dfd8e871..917544453f5 100644
--- 
a/docs/sql-manual/sql-functions/scalar-functions/date-time-functions/maketime.md
+++ 
b/docs/sql-manual/sql-functions/scalar-functions/date-time-functions/maketime.md
@@ -39,21 +39,21 @@ Returns a value of type TIME, in the format 
`hour:minute:second`. When the input
 SELECT `hour`, `minute`, `sec`, MAKETIME(`hour`, `minute`, `sec`) AS ans FROM 
`test_maketime`;
 ```
 ```text
-+------+-------+--------+---------+-------------------+
-| id   | hour  | minute | sec     | ans               |
-+------+-------+--------+---------+-------------------+
-|    1 |    12 |     15 |      30 | 12:15:30.000000   |
-|    2 |    14 |     56 | 12.5789 | 14:56:12.578900   |
-|    3 |  1234 |     11 |       4 | 838:59:59.000000  |
-|    4 | -1234 |      6 |      52 | -838:59:59.000000 |
-|    5 |    20 |     60 |      12 | NULL              |
-|    6 |    14 |     51 |      66 | NULL              |
-|    7 |  NULL |     15 |      16 | NULL              |
-|    8 |     7 |   NULL |       8 | NULL              |
-|    9 |     1 |      2 |    NULL | NULL              |
-|   10 |    23 |    -40 |      12 | NULL              |
-|   11 |    20 |      6 |     -12 | NULL              |
-+------+-------+--------+---------+-------------------+
++-------+--------+---------+-------------------+
+| hour  | minute | sec     | ans               |
++-------+--------+---------+-------------------+
+|    12 |     15 |      30 | 12:15:30.000000   |
+|    14 |     56 | 12.5789 | 14:56:12.578900   |
+|  1234 |     11 |       4 | 838:59:59.000000  |
+| -1234 |      6 |      52 | -838:59:59.000000 |
+|    20 |     60 |      12 | NULL              |
+|    14 |     51 |      66 | NULL              |
+|  NULL |     15 |      16 | NULL              |
+|     7 |   NULL |       8 | NULL              |
+|     1 |      2 |    NULL | NULL              |
+|    23 |    -40 |      12 | NULL              |
+|    20 |      6 |     -12 | NULL              |
++-------+--------+---------+-------------------+
 ```
 > Note:
 
diff --git 
a/docs/sql-manual/sql-functions/scalar-functions/date-time-functions/microsecond-timestamp.md
 
b/docs/sql-manual/sql-functions/scalar-functions/date-time-functions/microsecond-timestamp.md
index 4655ff787f7..0dc308a33b1 100644
--- 
a/docs/sql-manual/sql-functions/scalar-functions/date-time-functions/microsecond-timestamp.md
+++ 
b/docs/sql-manual/sql-functions/scalar-functions/date-time-functions/microsecond-timestamp.md
@@ -67,7 +67,7 @@ SELECT MICROSECOND_TIMESTAMP('2025-01-23 12:34:56.123456 
+15:00');
 -- If the input datetime is before 1970 (standard UTC), returns a negative 
value
 SELECT MICROSECOND_TIMESTAMP('1960-01-01 00:00:00 UTC');
 +---------------------------------------------------+
-| MICROSECOND_TIMESTAMP('1960-01-01 00:00:00 UTC') |
+| MICROSECOND_TIMESTAMP('1960-01-01 00:00:00 UTC')  |
 +---------------------------------------------------+
 |                                  -315619200000000 |
 +---------------------------------------------------+
diff --git 
a/docs/sql-manual/sql-functions/scalar-functions/date-time-functions/millisecond-timestamp.md
 
b/docs/sql-manual/sql-functions/scalar-functions/date-time-functions/millisecond-timestamp.md
index 0000575f75c..1c5494627f3 100644
--- 
a/docs/sql-manual/sql-functions/scalar-functions/date-time-functions/millisecond-timestamp.md
+++ 
b/docs/sql-manual/sql-functions/scalar-functions/date-time-functions/millisecond-timestamp.md
@@ -70,7 +70,7 @@ SELECT MILLISECOND_TIMESTAMP('1960-01-01 00:00:00 UTC');
 +---------------------------------------------------+
 | MILLISECOND_TIMESTAMP('1960-01-01 00:00:00 UTC') |
 +---------------------------------------------------+
-|                                  -315619200000000 |
+|                                     -315619200000 |
 +---------------------------------------------------+
 
 -- Input type is DATE, time part is automatically set to 00:00:00.000 (results 
are negative in East 8 time zone)
diff --git 
a/docs/sql-manual/sql-functions/scalar-functions/date-time-functions/minute-ceil.md
 
b/docs/sql-manual/sql-functions/scalar-functions/date-time-functions/minute-ceil.md
index 67269b5acde..22a9dec2333 100644
--- 
a/docs/sql-manual/sql-functions/scalar-functions/date-time-functions/minute-ceil.md
+++ 
b/docs/sql-manual/sql-functions/scalar-functions/date-time-functions/minute-ceil.md
@@ -34,7 +34,7 @@ MINUTE_CEIL(`<date_or_time_expr>`, `<period>`, `<origin>`)
 
 | Parameter | Description |
 | --------- | ----------- |
-| `<date_or_time_expr>` | The datetime value to be rounded up. Supports input 
of date/datetime/timestamptz types. For specific formats please see 
[timestamptz的转换](../../../../sql-manual/basic-element/sql-data-types/conversion/timestamptz-conversion),
 [datetime 
conversion](../../../../sql-manual/basic-element/sql-data-types/conversion/datetime-conversion)
 and [date 
conversion](../../../../sql-manual/basic-element/sql-data-types/conversion/date-conversion).
 |
+| `<date_or_time_expr>` | The datetime value to be rounded up. Supports input 
of date/datetime/timestamptz types. For specific formats please see 
[timestamptz 
conversion](../../../../sql-manual/basic-element/sql-data-types/conversion/timestamptz-conversion),
 [datetime 
conversion](../../../../sql-manual/basic-element/sql-data-types/conversion/datetime-conversion)
 and [date 
conversion](../../../../sql-manual/basic-element/sql-data-types/conversion/date-conversion).
 |
 | `<period>` | The minute interval value, of type INT, representing the number 
of minutes contained in each interval. |
 | `<origin>` | The starting time point of the interval, of type DATETIME. 
Default value is 0001-01-01 00:00:00. |
 
diff --git 
a/docs/sql-manual/sql-functions/scalar-functions/date-time-functions/minute-floor.md
 
b/docs/sql-manual/sql-functions/scalar-functions/date-time-functions/minute-floor.md
index 1179ee68d48..a121fd9d777 100644
--- 
a/docs/sql-manual/sql-functions/scalar-functions/date-time-functions/minute-floor.md
+++ 
b/docs/sql-manual/sql-functions/scalar-functions/date-time-functions/minute-floor.md
@@ -33,7 +33,7 @@ MINUTE_FLOOR(`<datetime>`, `<period>`, `<origin>`)
 
 | Parameter | Description |
 | --------- | ----------- |
-| `<datetime>` | The datetime value to be rounded down. Supports input of 
date/datetime/timestamptz types. For specific formats please see 
[timestamptz的转换](../../../../sql-manual/basic-element/sql-data-types/conversion/timestamptz-conversion),
 [datetime 
conversion](../../../../sql-manual/basic-element/sql-data-types/conversion/datetime-conversion)
 and [date 
conversion](../../../../sql-manual/basic-element/sql-data-types/conversion/date-conversion).
 |
+| `<datetime>` | The datetime value to be rounded down. Supports input of 
date/datetime/timestamptz types. For specific formats please see [timestamptz 
conversion](../../../../sql-manual/basic-element/sql-data-types/conversion/timestamptz-conversion),
 [datetime 
conversion](../../../../sql-manual/basic-element/sql-data-types/conversion/datetime-conversion)
 and [date 
conversion](../../../../sql-manual/basic-element/sql-data-types/conversion/date-conversion).
 |
 | `<period>` | The minute interval value, of type INT, representing the number 
of minutes contained in each interval. |
 | `<origin>` | The starting time point of the interval, of type DATETIME. 
Default value is 0001-01-01 00:00:00. |
 
@@ -67,7 +67,7 @@ SELECT MINUTE_FLOOR('2023-07-13 22:28:18.123', 5) AS result;
 +----------------------------+
 | result                     |
 +----------------------------+
-| 2023-07-13 22:25:00.000    |
+| 2023-07-13 22:25:00.000000 |
 +----------------------------+
 
 -- If input datetime is exactly at a period starting point, return the input 
datetime
@@ -128,7 +128,7 @@ SELECT MINUTE_FLOOR('2025-12-31 23:59:59+05:00', 
'2025-12-15 00:00:00.123');
 +----------------------------------------------------------------------+
 
 --- If the <origin> date and time is after the <period>, it will still be 
calculated according to the above formula, but the period k will be negative
-SELECT MINUTE_floor('0001-01-01 12:32:18', 5, '2028-07-03 22:20:00') AS result;
+SELECT MINUTE_FLOOR('0001-01-01 12:32:18', 5, '2028-07-03 22:20:00') AS result;
 +---------------------+
 | result              |
 +---------------------+
diff --git 
a/docs/sql-manual/sql-functions/scalar-functions/date-time-functions/month-floor.md
 
b/docs/sql-manual/sql-functions/scalar-functions/date-time-functions/month-floor.md
index b760cda0a40..20e7dd0581c 100644
--- 
a/docs/sql-manual/sql-functions/scalar-functions/date-time-functions/month-floor.md
+++ 
b/docs/sql-manual/sql-functions/scalar-functions/date-time-functions/month-floor.md
@@ -136,8 +136,8 @@ SELECT MONTH_FLOOR('2025-12-31 23:59:59+05:00', '2025-12-15 
00:00:00.123');
 +---------------------------------------------------------------------+
 
 -- Period is non-positive, returns error
-SELECT MINUTE_FLOOR('2023-07-13 22:28:18', -5) AS result;
-ERROR 1105 (HY000): errCode = 2, detailMessage = (10.16.10.3)[E-218]Operation 
minute_floor of 2023-07-13 22:28:18, -5 out of range
+SELECT MONTH_FLOOR('2023-07-13 22:28:18', -5) AS result;
+ERROR 1105 (HY000): errCode = 2, detailMessage = (10.16.10.3)[E-218]Operation 
month_floor of 2023-07-13 22:28:18, -5 out of range
 
 -- Any parameter is NULL, returns NULL
 SELECT MONTH_FLOOR(NULL, 5), MONTH_FLOOR('2023-07-13 22:28:18', NULL) AS 
result;
diff --git 
a/docs/sql-manual/sql-functions/scalar-functions/date-time-functions/period-add.md
 
b/docs/sql-manual/sql-functions/scalar-functions/date-time-functions/period-add.md
index 67be0e55529..bc8308e1f46 100644
--- 
a/docs/sql-manual/sql-functions/scalar-functions/date-time-functions/period-add.md
+++ 
b/docs/sql-manual/sql-functions/scalar-functions/date-time-functions/period-add.md
@@ -20,7 +20,7 @@ This function behaves consistently with MySQL's [PERIOD_ADD 
function](https://de
 ## Syntax
 
 ```sql
-PERIOD_ADD(`<period>`, `month`)
+PERIOD_ADD(`<period>`, `<month>`)
 ```
 
 ## Parameters
diff --git 
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/conditional-functions/overview.md
 
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/conditional-functions/overview.md
index 177496a49a0..112c2e2f4a4 100644
--- 
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/conditional-functions/overview.md
+++ 
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/conditional-functions/overview.md
@@ -52,11 +52,11 @@ mysql> select count(
     ->       cast(number as tinyint), 
     ->       cast(number as String))
     ->   ) from numbers("number" = "300");
-+-------------------------------------------------------------------------+
-| count(if(number < 128, cast(number as tinyint), cast(number as String)))|
-+-------------------------------------------------------------------------+
++--------------------------------------------------------------------------+
+| count(if(number < 128, cast(number as tinyint), cast(number as String))) |
++--------------------------------------------------------------------------+
 |                                                                      300 |
-+-------------------------------------------------------------------------+
++--------------------------------------------------------------------------+
 ```
 
 开启短路执行后，`if`、`ifnull`、`case`、`coalesce` 等函数在很多场景下可以避免不必要的计算，从而避免报错并提升性能。
diff --git 
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/date-time-functions/convert-tz.md
 
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/date-time-functions/convert-tz.md
index 7e3cc5f6d80..6d81b2d0b32 100644
--- 
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/date-time-functions/convert-tz.md
+++ 
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/date-time-functions/convert-tz.md
@@ -61,7 +61,7 @@ select CONVERT_TZ(CAST('2019-08-01 13:21:03' AS DATETIME), 
'+08:00', 'America/Lo
 -- 输入为 date 类型,输出为 datetime 类型，时间部分自动转换为 00:00:00
 mysql> select CONVERT_TZ(CAST('2019-08-01 13:21:03' AS DATE), 'Asia/Shanghai', 
'America/Los_Angeles');
 
+-------------------------------------------------------------------------------------------+
-| CONVERT_TZ(CAST('2019-08-01 13:21:03' AS DATEV2), 'Asia/Shanghai', 
'America/Los_Angeles') |
+| CONVERT_TZ(CAST('2019-08-01 13:21:03' AS DATE), 'Asia/Shanghai', 
'America/Los_Angeles')   |
 
+-------------------------------------------------------------------------------------------+
 | 2019-07-31 09:00:00                                                          
             |
 
+-------------------------------------------------------------------------------------------+
diff --git 
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/date-time-functions/date-trunc.md
 
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/date-time-functions/date-trunc.md
index ed49f22122d..02c4aa33c16 100644
--- 
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/date-time-functions/date-trunc.md
+++ 
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/date-time-functions/date-trunc.md
@@ -23,12 +23,12 @@ DATE_TRUNC(<time_unit>, <datetime>)
 
 | 参数 | 说明 |
 | -- | -- |
-| `<date_or_time_part>` | 合法的日期表达式，支持输入 date/datetime/timestamptz 类型，具体格式请查看 
[timestamptz的转换](../../../../sql-manual/basic-element/sql-data-types/conversion/timestamptz-conversion),
 [datetime 
的转换](../../../../../current/sql-manual/basic-element/sql-data-types/conversion/datetime-conversion)
 和 [date 
的转换](../../../../../current/sql-manual/basic-element/sql-data-types/conversion/date-conversion)
 |
+| `<datetime>` | 合法的日期表达式，支持输入 date/datetime/timestamptz 类型，具体格式请查看 
[timestamptz的转换](../../../../sql-manual/basic-element/sql-data-types/conversion/timestamptz-conversion),
 [datetime 
的转换](../../../../../current/sql-manual/basic-element/sql-data-types/conversion/datetime-conversion)
 和 [date 
的转换](../../../../../current/sql-manual/basic-element/sql-data-types/conversion/date-conversion)
 |
 | `<time_unit>` | 
希望截断的时间间隔，可选的值如下：[`second`,`minute`,`hour`,`day`,`week`,`month`,`quarter`,`year`]
 |
 
 ## 返回值
 
-返回类型与`<date_or_time_part>`类型保持一致， 
返回对应的日期时间类型截断之后的结果（即保留指定单位及更高层级的时间信息，将更低层级的时间信息清至最小日期时间）
+返回类型与`<datetime>`类型保持一致， 
返回对应的日期时间类型截断之后的结果（即保留指定单位及更高层级的时间信息，将更低层级的时间信息清至最小日期时间）
 - 若输入为 TIMESTAMPTZ 类型，则会先将其转换为 local_time(如：`2025-12-31 23:59:59+05:00` 
在会话变量为`+08:00`的情况下代表的local_time为`2026-01-01 02:59:59`)，再进行截断操作。
 - 对于带有 scale 的 datetime 类型，会截小数为零但保留 scale 返回.
 
diff --git 
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/date-time-functions/from-iso8601-date.md
 
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/date-time-functions/from-iso8601-date.md
index 35db5abb83c..6844a46107d 100644
--- 
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/date-time-functions/from-iso8601-date.md
+++ 
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/date-time-functions/from-iso8601-date.md
@@ -64,7 +64,7 @@ select
 | 0000-01-01 | 0000-02-28 | 0000-03-01 | 2024-12-31 |
 +------------+------------+------------+------------+
 
--- 解析“YYY-MMM-D”格式（每周以周一为第一天）,因为0522-01-01 才是周四，所以第一周之前的都会返回 0521 的年份
+-- 解析“YYYY-Www-D”格式（每周以周一为第一天）,因为0522-01-01 才是周四，所以第一周之前的都会返回 0521 的年份
 select from_iso8601_date('0522-W01-1') as week_1;
 +------------+
 | week_1     |
@@ -79,7 +79,7 @@ select from_iso8601_date('0522-W01-4') as week_4;
 | 0522-01-01 |
 +------------+
 
----YYY-MMM格式，第一周的周一在521年
+---YYYY-Www格式，第一周的周一在521年
 select from_iso8601_date('0522-W01') as week_1;
 +------------+
 | week_1     |
diff --git 
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/date-time-functions/maketime.md
 
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/date-time-functions/maketime.md
index 9419b0e1c15..61b93e30fe1 100644
--- 
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/date-time-functions/maketime.md
+++ 
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/date-time-functions/maketime.md
@@ -39,21 +39,21 @@ MAKETIME(`<hour>`, `<minute>`, `<second>`)
 SELECT `hour`, `minute`, `sec`, MAKETIME(`hour`, `minute`, `sec`) AS ans FROM 
`test_maketime`;
 ```
 ```text
-+------+-------+--------+---------+-------------------+
-| id   | hour  | minute | sec     | ans               |
-+------+-------+--------+---------+-------------------+
-|    1 |    12 |     15 |      30 | 12:15:30.000000   |
-|    2 |    14 |     56 | 12.5789 | 14:56:12.578900   |
-|    3 |  1234 |     11 |       4 | 838:59:59.000000  |
-|    4 | -1234 |      6 |      52 | -838:59:59.000000 |
-|    5 |    20 |     60 |      12 | NULL              |
-|    6 |    14 |     51 |      66 | NULL              |
-|    7 |  NULL |     15 |      16 | NULL              |
-|    8 |     7 |   NULL |       8 | NULL              |
-|    9 |     1 |      2 |    NULL | NULL              |
-|   10 |    23 |    -40 |      12 | NULL              |
-|   11 |    20 |      6 |     -12 | NULL              |
-+------+-------+--------+---------+-------------------+
++-------+--------+---------+-------------------+
+| hour  | minute | sec     | ans               |
++-------+--------+---------+-------------------+
+|    12 |     15 |      30 | 12:15:30.000000   |
+|    14 |     56 | 12.5789 | 14:56:12.578900   |
+|  1234 |     11 |       4 | 838:59:59.000000  |
+| -1234 |      6 |      52 | -838:59:59.000000 |
+|    20 |     60 |      12 | NULL              |
+|    14 |     51 |      66 | NULL              |
+|  NULL |     15 |      16 | NULL              |
+|     7 |   NULL |       8 | NULL              |
+|     1 |      2 |    NULL | NULL              |
+|    23 |    -40 |      12 | NULL              |
+|    20 |      6 |     -12 | NULL              |
++-------+--------+---------+-------------------+
 ```
 > 注：
 > 1. `sec` 列类型为 Float，所以输出格式全部为六位精度的时间值
diff --git 
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/date-time-functions/millisecond-timestamp.md
 
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/date-time-functions/millisecond-timestamp.md
index cdcb454e8e1..66f43e9a455 100644
--- 
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/date-time-functions/millisecond-timestamp.md
+++ 
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/date-time-functions/millisecond-timestamp.md
@@ -70,7 +70,7 @@ SELECT MILLISECOND_TIMESTAMP('1960-01-01 00:00:00  UTC');
 +---------------------------------------------------+
 | MILLISECOND_TIMESTAMP('1960-01-01 00:00:00  UTC') |
 +---------------------------------------------------+
-|                                  -315619200000000 |
+|                                     -315619200000 |
 +---------------------------------------------------+
 
 ---输入 date 类型，时间部分自动设置为 00:00:00.000(因为在东八区，所有结果为负数)
diff --git 
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/date-time-functions/minute-floor.md
 
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/date-time-functions/minute-floor.md
index 9492e93d571..1db020cfedd 100644
--- 
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/date-time-functions/minute-floor.md
+++ 
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/date-time-functions/minute-floor.md
@@ -69,7 +69,7 @@ SELECT MINUTE_FLOOR('2023-07-13 22:28:18.123', 5) AS result;
 +----------------------------+
 | result                     |
 +----------------------------+
-| 2023-07-13 22:25:00.000    |
+| 2023-07-13 22:25:00.000000 |
 +----------------------------+
 
 -- 输入日期时间恰好是周期起点，则返回输入日期时间
@@ -105,7 +105,7 @@ SELECT MINUTE_FLOOR('2023-07-13 22:28:18.456789', 5) AS 
result;
 +----------------------------+
 
 --- 若 <origin> 日期时间在 <period> 之后，也会按照上述公式计算，不过周期 k 为负数。
-SELECT MINUTE_floor('0001-01-01 12:32:18', 5, '2028-07-03 22:20:00') AS result;
+SELECT MINUTE_FLOOR('0001-01-01 12:32:18', 5, '2028-07-03 22:20:00') AS result;
 +---------------------+
 | result              |
 +---------------------+
diff --git 
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/date-time-functions/period-add.md
 
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/date-time-functions/period-add.md
index ccbcfeb3905..581b9fe8025 100644
--- 
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/date-time-functions/period-add.md
+++ 
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/date-time-functions/period-add.md
@@ -20,7 +20,7 @@
 ## 语法
 
 ```sql
-PERIOD_ADD(`<period>`, `month`)
+PERIOD_ADD(`<period>`, `<month>`)
 ```
 
 ## 参数
diff --git 
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/scalar-functions/conditional-functions/overview.md
 
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/scalar-functions/conditional-functions/overview.md
index 177496a49a0..112c2e2f4a4 100644
--- 
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/scalar-functions/conditional-functions/overview.md
+++ 
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/scalar-functions/conditional-functions/overview.md
@@ -52,11 +52,11 @@ mysql> select count(
     ->       cast(number as tinyint), 
     ->       cast(number as String))
     ->   ) from numbers("number" = "300");
-+-------------------------------------------------------------------------+
-| count(if(number < 128, cast(number as tinyint), cast(number as String)))|
-+-------------------------------------------------------------------------+
++--------------------------------------------------------------------------+
+| count(if(number < 128, cast(number as tinyint), cast(number as String))) |
++--------------------------------------------------------------------------+
 |                                                                      300 |
-+-------------------------------------------------------------------------+
++--------------------------------------------------------------------------+
 ```
 
 开启短路执行后，`if`、`ifnull`、`case`、`coalesce` 等函数在很多场景下可以避免不必要的计算，从而避免报错并提升性能。
diff --git 
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/scalar-functions/date-time-functions/convert-tz.md
 
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/scalar-functions/date-time-functions/convert-tz.md
index 7e3cc5f6d80..6d81b2d0b32 100644
--- 
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/scalar-functions/date-time-functions/convert-tz.md
+++ 
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/scalar-functions/date-time-functions/convert-tz.md
@@ -61,7 +61,7 @@ select CONVERT_TZ(CAST('2019-08-01 13:21:03' AS DATETIME), 
'+08:00', 'America/Lo
 -- 输入为 date 类型,输出为 datetime 类型，时间部分自动转换为 00:00:00
 mysql> select CONVERT_TZ(CAST('2019-08-01 13:21:03' AS DATE), 'Asia/Shanghai', 
'America/Los_Angeles');
 
+-------------------------------------------------------------------------------------------+
-| CONVERT_TZ(CAST('2019-08-01 13:21:03' AS DATEV2), 'Asia/Shanghai', 
'America/Los_Angeles') |
+| CONVERT_TZ(CAST('2019-08-01 13:21:03' AS DATE), 'Asia/Shanghai', 
'America/Los_Angeles')   |
 
+-------------------------------------------------------------------------------------------+
 | 2019-07-31 09:00:00                                                          
             |
 
+-------------------------------------------------------------------------------------------+
diff --git 
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/scalar-functions/date-time-functions/date-trunc.md
 
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/scalar-functions/date-time-functions/date-trunc.md
index ed49f22122d..02c4aa33c16 100644
--- 
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/scalar-functions/date-time-functions/date-trunc.md
+++ 
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/scalar-functions/date-time-functions/date-trunc.md
@@ -23,12 +23,12 @@ DATE_TRUNC(<time_unit>, <datetime>)
 
 | 参数 | 说明 |
 | -- | -- |
-| `<date_or_time_part>` | 合法的日期表达式，支持输入 date/datetime/timestamptz 类型，具体格式请查看 
[timestamptz的转换](../../../../sql-manual/basic-element/sql-data-types/conversion/timestamptz-conversion),
 [datetime 
的转换](../../../../../current/sql-manual/basic-element/sql-data-types/conversion/datetime-conversion)
 和 [date 
的转换](../../../../../current/sql-manual/basic-element/sql-data-types/conversion/date-conversion)
 |
+| `<datetime>` | 合法的日期表达式，支持输入 date/datetime/timestamptz 类型，具体格式请查看 
[timestamptz的转换](../../../../sql-manual/basic-element/sql-data-types/conversion/timestamptz-conversion),
 [datetime 
的转换](../../../../../current/sql-manual/basic-element/sql-data-types/conversion/datetime-conversion)
 和 [date 
的转换](../../../../../current/sql-manual/basic-element/sql-data-types/conversion/date-conversion)
 |
 | `<time_unit>` | 
希望截断的时间间隔，可选的值如下：[`second`,`minute`,`hour`,`day`,`week`,`month`,`quarter`,`year`]
 |
 
 ## 返回值
 
-返回类型与`<date_or_time_part>`类型保持一致， 
返回对应的日期时间类型截断之后的结果（即保留指定单位及更高层级的时间信息，将更低层级的时间信息清至最小日期时间）
+返回类型与`<datetime>`类型保持一致， 
返回对应的日期时间类型截断之后的结果（即保留指定单位及更高层级的时间信息，将更低层级的时间信息清至最小日期时间）
 - 若输入为 TIMESTAMPTZ 类型，则会先将其转换为 local_time(如：`2025-12-31 23:59:59+05:00` 
在会话变量为`+08:00`的情况下代表的local_time为`2026-01-01 02:59:59`)，再进行截断操作。
 - 对于带有 scale 的 datetime 类型，会截小数为零但保留 scale 返回.
 
diff --git 
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/scalar-functions/date-time-functions/from-iso8601-date.md
 
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/scalar-functions/date-time-functions/from-iso8601-date.md
index 35db5abb83c..6844a46107d 100644
--- 
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/scalar-functions/date-time-functions/from-iso8601-date.md
+++ 
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/scalar-functions/date-time-functions/from-iso8601-date.md
@@ -64,7 +64,7 @@ select
 | 0000-01-01 | 0000-02-28 | 0000-03-01 | 2024-12-31 |
 +------------+------------+------------+------------+
 
--- 解析“YYY-MMM-D”格式（每周以周一为第一天）,因为0522-01-01 才是周四，所以第一周之前的都会返回 0521 的年份
+-- 解析“YYYY-Www-D”格式（每周以周一为第一天）,因为0522-01-01 才是周四，所以第一周之前的都会返回 0521 的年份
 select from_iso8601_date('0522-W01-1') as week_1;
 +------------+
 | week_1     |
@@ -79,7 +79,7 @@ select from_iso8601_date('0522-W01-4') as week_4;
 | 0522-01-01 |
 +------------+
 
----YYY-MMM格式，第一周的周一在521年
+---YYYY-Www格式，第一周的周一在521年
 select from_iso8601_date('0522-W01') as week_1;
 +------------+
 | week_1     |
diff --git 
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/scalar-functions/date-time-functions/maketime.md
 
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/scalar-functions/date-time-functions/maketime.md
index 9419b0e1c15..61b93e30fe1 100644
--- 
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/scalar-functions/date-time-functions/maketime.md
+++ 
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/scalar-functions/date-time-functions/maketime.md
@@ -39,21 +39,21 @@ MAKETIME(`<hour>`, `<minute>`, `<second>`)
 SELECT `hour`, `minute`, `sec`, MAKETIME(`hour`, `minute`, `sec`) AS ans FROM 
`test_maketime`;
 ```
 ```text
-+------+-------+--------+---------+-------------------+
-| id   | hour  | minute | sec     | ans               |
-+------+-------+--------+---------+-------------------+
-|    1 |    12 |     15 |      30 | 12:15:30.000000   |
-|    2 |    14 |     56 | 12.5789 | 14:56:12.578900   |
-|    3 |  1234 |     11 |       4 | 838:59:59.000000  |
-|    4 | -1234 |      6 |      52 | -838:59:59.000000 |
-|    5 |    20 |     60 |      12 | NULL              |
-|    6 |    14 |     51 |      66 | NULL              |
-|    7 |  NULL |     15 |      16 | NULL              |
-|    8 |     7 |   NULL |       8 | NULL              |
-|    9 |     1 |      2 |    NULL | NULL              |
-|   10 |    23 |    -40 |      12 | NULL              |
-|   11 |    20 |      6 |     -12 | NULL              |
-+------+-------+--------+---------+-------------------+
++-------+--------+---------+-------------------+
+| hour  | minute | sec     | ans               |
++-------+--------+---------+-------------------+
+|    12 |     15 |      30 | 12:15:30.000000   |
+|    14 |     56 | 12.5789 | 14:56:12.578900   |
+|  1234 |     11 |       4 | 838:59:59.000000  |
+| -1234 |      6 |      52 | -838:59:59.000000 |
+|    20 |     60 |      12 | NULL              |
+|    14 |     51 |      66 | NULL              |
+|  NULL |     15 |      16 | NULL              |
+|     7 |   NULL |       8 | NULL              |
+|     1 |      2 |    NULL | NULL              |
+|    23 |    -40 |      12 | NULL              |
+|    20 |      6 |     -12 | NULL              |
++-------+--------+---------+-------------------+
 ```
 > 注：
 > 1. `sec` 列类型为 Float，所以输出格式全部为六位精度的时间值
diff --git 
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/scalar-functions/date-time-functions/millisecond-timestamp.md
 
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/scalar-functions/date-time-functions/millisecond-timestamp.md
index cdcb454e8e1..66f43e9a455 100644
--- 
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/scalar-functions/date-time-functions/millisecond-timestamp.md
+++ 
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/scalar-functions/date-time-functions/millisecond-timestamp.md
@@ -70,7 +70,7 @@ SELECT MILLISECOND_TIMESTAMP('1960-01-01 00:00:00  UTC');
 +---------------------------------------------------+
 | MILLISECOND_TIMESTAMP('1960-01-01 00:00:00  UTC') |
 +---------------------------------------------------+
-|                                  -315619200000000 |
+|                                     -315619200000 |
 +---------------------------------------------------+
 
 ---输入 date 类型，时间部分自动设置为 00:00:00.000(因为在东八区，所有结果为负数)
diff --git 
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/scalar-functions/date-time-functions/minute-floor.md
 
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/scalar-functions/date-time-functions/minute-floor.md
index 9492e93d571..1db020cfedd 100644
--- 
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/scalar-functions/date-time-functions/minute-floor.md
+++ 
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/scalar-functions/date-time-functions/minute-floor.md
@@ -69,7 +69,7 @@ SELECT MINUTE_FLOOR('2023-07-13 22:28:18.123', 5) AS result;
 +----------------------------+
 | result                     |
 +----------------------------+
-| 2023-07-13 22:25:00.000    |
+| 2023-07-13 22:25:00.000000 |
 +----------------------------+
 
 -- 输入日期时间恰好是周期起点，则返回输入日期时间
@@ -105,7 +105,7 @@ SELECT MINUTE_FLOOR('2023-07-13 22:28:18.456789', 5) AS 
result;
 +----------------------------+
 
 --- 若 <origin> 日期时间在 <period> 之后，也会按照上述公式计算，不过周期 k 为负数。
-SELECT MINUTE_floor('0001-01-01 12:32:18', 5, '2028-07-03 22:20:00') AS result;
+SELECT MINUTE_FLOOR('0001-01-01 12:32:18', 5, '2028-07-03 22:20:00') AS result;
 +---------------------+
 | result              |
 +---------------------+
diff --git 
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/scalar-functions/date-time-functions/period-add.md
 
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/scalar-functions/date-time-functions/period-add.md
index ccbcfeb3905..581b9fe8025 100644
--- 
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/scalar-functions/date-time-functions/period-add.md
+++ 
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/scalar-functions/date-time-functions/period-add.md
@@ -20,7 +20,7 @@
 ## 语法
 
 ```sql
-PERIOD_ADD(`<period>`, `month`)
+PERIOD_ADD(`<period>`, `<month>`)
 ```
 
 ## 参数
diff --git 
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/conditional-functions/not-null-or-empty.md
 
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/conditional-functions/not-null-or-empty.md
index 07ad7724c65..e470a3fff24 100644
--- 
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/conditional-functions/not-null-or-empty.md
+++ 
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/conditional-functions/not-null-or-empty.md
@@ -25,7 +25,7 @@ Returns false if the string is an empty string or NULL; 
otherwise, returns true.
 ## Examples
 1. Example 1
     ```sql
-    select not_null_or_empty(null), not_null_or_empty("");, 
not_null_or_empty(" ");
+    select not_null_or_empty(null), not_null_or_empty(""), not_null_or_empty(" 
");
     ```
     ```text
     
+-------------------------+-----------------------+------------------------+
diff --git 
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/conditional-functions/null-or-empty.md
 
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/conditional-functions/null-or-empty.md
index c570b484e39..88b8788aeb3 100644
--- 
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/conditional-functions/null-or-empty.md
+++ 
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/conditional-functions/null-or-empty.md
@@ -2,13 +2,13 @@
 {
     "title": "NULL_OR_EMPTY",
     "language": "en",
-    "description": "The nullorempty function is used to determine whether the 
given value is not NULL and not empty. If the input value is neither NULL nor 
empty,"
+    "description": "The nullorempty function is used to determine whether the 
given value is NULL or empty. If the input value is NULL or empty,"
 }
 ---
 
 ## Description
 
-The `null_or_empty` function is used to determine whether the given value is 
not NULL and not empty. If the input value is neither NULL nor empty, it 
returns true; otherwise, it returns false.
+The `null_or_empty` function is used to determine whether the given value is 
NULL or empty. If the input value is NULL or empty, it returns true; otherwise, 
it returns false.
 
 ## Syntax
 
@@ -25,7 +25,7 @@ Returns true if the string is an empty string or NULL; 
otherwise, returns false.
 ## Examples
 1. Example 1
     ```sql
-    select null_or_empty(null), null_or_empty("");, null_or_empty(" ");
+    select null_or_empty(null), null_or_empty(""), null_or_empty(" ");
     ```
     ```text
     +---------------------+-------------------+--------------------+
diff --git 
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/conditional-functions/overview.md
 
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/conditional-functions/overview.md
index 4f24fe0458f..3ab0b5cad35 100644
--- 
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/conditional-functions/overview.md
+++ 
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/conditional-functions/overview.md
@@ -52,11 +52,11 @@ mysql> select count(
     ->       cast(number as tinyint), 
     ->       cast(number as String))
     ->   ) from numbers("number" = "300");
-+-------------------------------------------------------------------------+
-| count(if(number < 128, cast(number as tinyint), cast(number as String)))|
-+-------------------------------------------------------------------------+
++--------------------------------------------------------------------------+
+| count(if(number < 128, cast(number as tinyint), cast(number as String))) |
++--------------------------------------------------------------------------+
 |                                                                      300 |
-+-------------------------------------------------------------------------+
++--------------------------------------------------------------------------+
 ```
 
 With short-circuit evaluation enabled, functions like `if`, `ifnull`, `case`, 
and `coalesce` can avoid unnecessary computations in many scenarios, thus 
preventing errors and improving performance.
diff --git 
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/date-time-functions/convert-tz.md
 
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/date-time-functions/convert-tz.md
index 990d4d1b0d2..ed328d9253f 100644
--- 
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/date-time-functions/convert-tz.md
+++ 
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/date-time-functions/convert-tz.md
@@ -62,7 +62,7 @@ mysql> select CONVERT_TZ(CAST('2019-08-01 13:21:03' AS 
DATETIME), '+08:00', 'Ame
 -- For date type input,return datetime type value, the time part is 
automatically converted to 00:00:00
 mysql> select CONVERT_TZ(CAST('2019-08-01 13:21:03' AS DATE), 'Asia/Shanghai', 
'America/Los_Angeles');
 
+-------------------------------------------------------------------------------------------+
-| CONVERT_TZ(CAST('2019-08-01 13:21:03' AS DATEV2), 'Asia/Shanghai', 
'America/Los_Angeles') |
+| CONVERT_TZ(CAST('2019-08-01 13:21:03' AS DATE), 'Asia/Shanghai', 
'America/Los_Angeles')   |
 
+-------------------------------------------------------------------------------------------+
 | 2019-07-31 09:00:00                                                          
             |
 
+-------------------------------------------------------------------------------------------+
diff --git 
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/date-time-functions/date-sub.md
 
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/date-time-functions/date-sub.md
index 0a082611c22..61edc0c5b79 100644
--- 
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/date-time-functions/date-sub.md
+++ 
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/date-time-functions/date-sub.md
@@ -181,4 +181,3 @@ ERROR 1105 (HY000): errCode = 2, detailMessage = 
(10.16.10.3)[E-218]Operation da
 select date_sub('9999-01-01', INTERVAL -1 YEAR);
 ERROR 1105 (HY000): errCode = 2, detailMessage = (10.16.10.3)[E-218]Operation 
year_add of 9999-01-01, 1 out of range
 ```
-```
\ No newline at end of file
diff --git 
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/date-time-functions/date-trunc.md
 
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/date-time-functions/date-trunc.md
index ba659d94195..b372f61c876 100644
--- 
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/date-time-functions/date-trunc.md
+++ 
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/date-time-functions/date-trunc.md
@@ -21,7 +21,7 @@ DATE_TRUNC(<time_unit>, <datetime>)
 
 | Parameter | Description |
 | -- | -- |
-| `<date_or_time_part>` | A valid date expression, supporting datetime or date 
type. For specific formats, please refer to [timestamptz 
conversion](../../../../sql-manual/basic-element/sql-data-types/conversion/timestamptz-conversion),
 [datetime 
conversion](../../../../sql-manual/basic-element/sql-data-types/conversion/datetime-conversion)
 and [date 
conversion](../../../../sql-manual/basic-element/sql-data-types/conversion/date-conversion)
 |
+| `<datetime>` | A valid date expression, supporting datetime or date type. 
For specific formats, please refer to [timestamptz 
conversion](../../../../sql-manual/basic-element/sql-data-types/conversion/timestamptz-conversion),
 [datetime 
conversion](../../../../sql-manual/basic-element/sql-data-types/conversion/datetime-conversion)
 and [date 
conversion](../../../../sql-manual/basic-element/sql-data-types/conversion/date-conversion)
 |
 | `<time_unit>` | The time interval to truncate to. The available values are: 
[`second`,`minute`,`hour`,`day`,`week`,`month`,`quarter`,`year`] |
 
 ## Return Value
diff --git 
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/date-time-functions/from-iso8601-date.md
 
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/date-time-functions/from-iso8601-date.md
index 6632dc6bc35..25aa62ccb3b 100644
--- 
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/date-time-functions/from-iso8601-date.md
+++ 
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/date-time-functions/from-iso8601-date.md
@@ -65,7 +65,7 @@ select
 | 0000-01-01 | 0000-02-28 | 0000-03-01 | 2024-12-31 |
 +------------+------------+------------+------------+
 
--- Parse "YYY-MMM-D" format (each week starts with Monday), since 0522-01-01 
is Thursday, dates before the first week will return year 0521
+-- Parse "YYYY-Www-D" format (each week starts with Monday), since 0522-01-01 
is Thursday, dates before the first week will return year 0521
 select from_iso8601_date('0522-W01-1') as week_1;
 +------------+
 | week_1     |
@@ -81,7 +81,7 @@ select from_iso8601_date('0522-W01-4') as week_4;
 | 0522-01-01 |
 +------------+
 
----YYY-MMM format, Monday of the first week is in year 521
+---YYYY-Www format, Monday of the first week is in year 521
 select from_iso8601_date('0522-W01') as week_1;
 +------------+
 | week_1     |
diff --git 
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/date-time-functions/hour-ceil.md
 
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/date-time-functions/hour-ceil.md
index 4ac77198cae..42afaec7d00 100644
--- 
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/date-time-functions/hour-ceil.md
+++ 
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/date-time-functions/hour-ceil.md
@@ -34,7 +34,7 @@ HOUR_CEIL(`<date_or_time_expr>`, `<period>`, `<origin>`)
 
 | Parameter | Description |
 | -- | -- |
-| `<date_or_time_expr>` | A valid date expression that supports 
datetime/date/timestamptz types. Date type will be converted to the start of 
the day at 00:00:00. For specific formats please see 
[timestamptz的转换](../../../../sql-manual/basic-element/sql-data-types/conversion/timestamptz-conversion),
 and for datetime/date formats refer to [datetime 
conversion](../../../../sql-manual/basic-element/sql-data-types/conversion/datetime-conversion)
 and [date conversion](../../../../sql-manual/bas [...]
+| `<date_or_time_expr>` | A valid date expression that supports 
datetime/date/timestamptz types. Date type will be converted to the start of 
the day at 00:00:00. For specific formats please see [timestamptz 
conversion](../../../../sql-manual/basic-element/sql-data-types/conversion/timestamptz-conversion),
 and for datetime/date formats refer to [datetime 
conversion](../../../../sql-manual/basic-element/sql-data-types/conversion/datetime-conversion)
 and [date conversion](../../../../sql-ma [...]
 | `<period>` | Optional parameter that specifies the period length (unit: 
hours), must be a positive integer (such as 1, 3, 5). Default value is 1, 
representing one period every 1 hour |
 | `<origin>` | The starting time origin, supports datetime and date types. If 
not provided, the default is 0001-01-01T00:00:00 |
 
diff --git 
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/date-time-functions/maketime.md
 
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/date-time-functions/maketime.md
index 019dfd8e871..917544453f5 100644
--- 
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/date-time-functions/maketime.md
+++ 
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/date-time-functions/maketime.md
@@ -39,21 +39,21 @@ Returns a value of type TIME, in the format 
`hour:minute:second`. When the input
 SELECT `hour`, `minute`, `sec`, MAKETIME(`hour`, `minute`, `sec`) AS ans FROM 
`test_maketime`;
 ```
 ```text
-+------+-------+--------+---------+-------------------+
-| id   | hour  | minute | sec     | ans               |
-+------+-------+--------+---------+-------------------+
-|    1 |    12 |     15 |      30 | 12:15:30.000000   |
-|    2 |    14 |     56 | 12.5789 | 14:56:12.578900   |
-|    3 |  1234 |     11 |       4 | 838:59:59.000000  |
-|    4 | -1234 |      6 |      52 | -838:59:59.000000 |
-|    5 |    20 |     60 |      12 | NULL              |
-|    6 |    14 |     51 |      66 | NULL              |
-|    7 |  NULL |     15 |      16 | NULL              |
-|    8 |     7 |   NULL |       8 | NULL              |
-|    9 |     1 |      2 |    NULL | NULL              |
-|   10 |    23 |    -40 |      12 | NULL              |
-|   11 |    20 |      6 |     -12 | NULL              |
-+------+-------+--------+---------+-------------------+
++-------+--------+---------+-------------------+
+| hour  | minute | sec     | ans               |
++-------+--------+---------+-------------------+
+|    12 |     15 |      30 | 12:15:30.000000   |
+|    14 |     56 | 12.5789 | 14:56:12.578900   |
+|  1234 |     11 |       4 | 838:59:59.000000  |
+| -1234 |      6 |      52 | -838:59:59.000000 |
+|    20 |     60 |      12 | NULL              |
+|    14 |     51 |      66 | NULL              |
+|  NULL |     15 |      16 | NULL              |
+|     7 |   NULL |       8 | NULL              |
+|     1 |      2 |    NULL | NULL              |
+|    23 |    -40 |      12 | NULL              |
+|    20 |      6 |     -12 | NULL              |
++-------+--------+---------+-------------------+
 ```
 > Note:
 
diff --git 
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/date-time-functions/microsecond-timestamp.md
 
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/date-time-functions/microsecond-timestamp.md
index 4655ff787f7..0dc308a33b1 100644
--- 
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/date-time-functions/microsecond-timestamp.md
+++ 
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/date-time-functions/microsecond-timestamp.md
@@ -67,7 +67,7 @@ SELECT MICROSECOND_TIMESTAMP('2025-01-23 12:34:56.123456 
+15:00');
 -- If the input datetime is before 1970 (standard UTC), returns a negative 
value
 SELECT MICROSECOND_TIMESTAMP('1960-01-01 00:00:00 UTC');
 +---------------------------------------------------+
-| MICROSECOND_TIMESTAMP('1960-01-01 00:00:00 UTC') |
+| MICROSECOND_TIMESTAMP('1960-01-01 00:00:00 UTC')  |
 +---------------------------------------------------+
 |                                  -315619200000000 |
 +---------------------------------------------------+
diff --git 
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/date-time-functions/millisecond-timestamp.md
 
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/date-time-functions/millisecond-timestamp.md
index 0000575f75c..1c5494627f3 100644
--- 
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/date-time-functions/millisecond-timestamp.md
+++ 
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/date-time-functions/millisecond-timestamp.md
@@ -70,7 +70,7 @@ SELECT MILLISECOND_TIMESTAMP('1960-01-01 00:00:00 UTC');
 +---------------------------------------------------+
 | MILLISECOND_TIMESTAMP('1960-01-01 00:00:00 UTC') |
 +---------------------------------------------------+
-|                                  -315619200000000 |
+|                                     -315619200000 |
 +---------------------------------------------------+
 
 -- Input type is DATE, time part is automatically set to 00:00:00.000 (results 
are negative in East 8 time zone)
diff --git 
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/date-time-functions/minute-ceil.md
 
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/date-time-functions/minute-ceil.md
index 67269b5acde..22a9dec2333 100644
--- 
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/date-time-functions/minute-ceil.md
+++ 
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/date-time-functions/minute-ceil.md
@@ -34,7 +34,7 @@ MINUTE_CEIL(`<date_or_time_expr>`, `<period>`, `<origin>`)
 
 | Parameter | Description |
 | --------- | ----------- |
-| `<date_or_time_expr>` | The datetime value to be rounded up. Supports input 
of date/datetime/timestamptz types. For specific formats please see 
[timestamptz的转换](../../../../sql-manual/basic-element/sql-data-types/conversion/timestamptz-conversion),
 [datetime 
conversion](../../../../sql-manual/basic-element/sql-data-types/conversion/datetime-conversion)
 and [date 
conversion](../../../../sql-manual/basic-element/sql-data-types/conversion/date-conversion).
 |
+| `<date_or_time_expr>` | The datetime value to be rounded up. Supports input 
of date/datetime/timestamptz types. For specific formats please see 
[timestamptz 
conversion](../../../../sql-manual/basic-element/sql-data-types/conversion/timestamptz-conversion),
 [datetime 
conversion](../../../../sql-manual/basic-element/sql-data-types/conversion/datetime-conversion)
 and [date 
conversion](../../../../sql-manual/basic-element/sql-data-types/conversion/date-conversion).
 |
 | `<period>` | The minute interval value, of type INT, representing the number 
of minutes contained in each interval. |
 | `<origin>` | The starting time point of the interval, of type DATETIME. 
Default value is 0001-01-01 00:00:00. |
 
diff --git 
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/date-time-functions/minute-floor.md
 
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/date-time-functions/minute-floor.md
index 1179ee68d48..a121fd9d777 100644
--- 
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/date-time-functions/minute-floor.md
+++ 
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/date-time-functions/minute-floor.md
@@ -33,7 +33,7 @@ MINUTE_FLOOR(`<datetime>`, `<period>`, `<origin>`)
 
 | Parameter | Description |
 | --------- | ----------- |
-| `<datetime>` | The datetime value to be rounded down. Supports input of 
date/datetime/timestamptz types. For specific formats please see 
[timestamptz的转换](../../../../sql-manual/basic-element/sql-data-types/conversion/timestamptz-conversion),
 [datetime 
conversion](../../../../sql-manual/basic-element/sql-data-types/conversion/datetime-conversion)
 and [date 
conversion](../../../../sql-manual/basic-element/sql-data-types/conversion/date-conversion).
 |
+| `<datetime>` | The datetime value to be rounded down. Supports input of 
date/datetime/timestamptz types. For specific formats please see [timestamptz 
conversion](../../../../sql-manual/basic-element/sql-data-types/conversion/timestamptz-conversion),
 [datetime 
conversion](../../../../sql-manual/basic-element/sql-data-types/conversion/datetime-conversion)
 and [date 
conversion](../../../../sql-manual/basic-element/sql-data-types/conversion/date-conversion).
 |
 | `<period>` | The minute interval value, of type INT, representing the number 
of minutes contained in each interval. |
 | `<origin>` | The starting time point of the interval, of type DATETIME. 
Default value is 0001-01-01 00:00:00. |
 
@@ -67,7 +67,7 @@ SELECT MINUTE_FLOOR('2023-07-13 22:28:18.123', 5) AS result;
 +----------------------------+
 | result                     |
 +----------------------------+
-| 2023-07-13 22:25:00.000    |
+| 2023-07-13 22:25:00.000000 |
 +----------------------------+
 
 -- If input datetime is exactly at a period starting point, return the input 
datetime
@@ -128,7 +128,7 @@ SELECT MINUTE_FLOOR('2025-12-31 23:59:59+05:00', 
'2025-12-15 00:00:00.123');
 +----------------------------------------------------------------------+
 
 --- If the <origin> date and time is after the <period>, it will still be 
calculated according to the above formula, but the period k will be negative
-SELECT MINUTE_floor('0001-01-01 12:32:18', 5, '2028-07-03 22:20:00') AS result;
+SELECT MINUTE_FLOOR('0001-01-01 12:32:18', 5, '2028-07-03 22:20:00') AS result;
 +---------------------+
 | result              |
 +---------------------+
diff --git 
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/date-time-functions/month-floor.md
 
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/date-time-functions/month-floor.md
index b760cda0a40..20e7dd0581c 100644
--- 
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/date-time-functions/month-floor.md
+++ 
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/date-time-functions/month-floor.md
@@ -136,8 +136,8 @@ SELECT MONTH_FLOOR('2025-12-31 23:59:59+05:00', '2025-12-15 
00:00:00.123');
 +---------------------------------------------------------------------+
 
 -- Period is non-positive, returns error
-SELECT MINUTE_FLOOR('2023-07-13 22:28:18', -5) AS result;
-ERROR 1105 (HY000): errCode = 2, detailMessage = (10.16.10.3)[E-218]Operation 
minute_floor of 2023-07-13 22:28:18, -5 out of range
+SELECT MONTH_FLOOR('2023-07-13 22:28:18', -5) AS result;
+ERROR 1105 (HY000): errCode = 2, detailMessage = (10.16.10.3)[E-218]Operation 
month_floor of 2023-07-13 22:28:18, -5 out of range
 
 -- Any parameter is NULL, returns NULL
 SELECT MONTH_FLOOR(NULL, 5), MONTH_FLOOR('2023-07-13 22:28:18', NULL) AS 
result;
diff --git 
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/date-time-functions/period-add.md
 
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/date-time-functions/period-add.md
index 67be0e55529..bc8308e1f46 100644
--- 
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/date-time-functions/period-add.md
+++ 
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/date-time-functions/period-add.md
@@ -20,7 +20,7 @@ This function behaves consistently with MySQL's [PERIOD_ADD 
function](https://de
 ## Syntax
 
 ```sql
-PERIOD_ADD(`<period>`, `month`)
+PERIOD_ADD(`<period>`, `<month>`)
 ```
 
 ## Parameters


---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

(doris-website) branch master updated: [fix] correct typos / mislabeled examples / table alignment in conditional and date-time function docs (#3709)

Reply via email to