(doris-website) branch master updated: [fix] correct date-time and encrypt-digest function doc issues (#3710)

morningman Wed, 20 May 2026 09:26:24 -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 f72bb03f348 [fix] correct date-time and encrypt-digest function doc 
issues (#3710)
f72bb03f348 is described below

commit f72bb03f348e08944882d03413cd7debab55f00b
Author: boluor <[email protected]>
AuthorDate: Wed May 20 08:59:59 2026 -0700

    [fix] correct date-time and encrypt-digest function doc issues (#3710)
    
    ## Summary
    
    Fixes 19 small documentation issues across the date-time and
    encrypt-digest function references. Each item below is independent.
    
    ### date-time-functions
    
    - **quarters-add.md** — error messages in two `out of range` examples
    named `month_add` (a copy-paste from `months-add.md`); corrected to
    `quarters_add`.
    - **sec-to-time.md** — the description gave the seconds bound of TIME as
    `±3023999`; the real max for `838:59:59` is `3020399` (`838*3600 + 59*60
    + 59`). Both occurrences corrected.
    - **second-ceil.md / second-floor.md** — Return Value paragraph used
    `\`<date_or_time_expr>\`` while the parameters table uses
    `\`<datetime>\``; unified on `\`<datetime>\``. The same files also had a
    leftover Chinese link label `[timestamptz的转换]` inside the English doc;
    replaced with `[timestamptz conversion]`.
    - **sub-time.md / add-time.md** — two of the three relative links in the
    parameter row had an extra `../` and a stray literal `docs/` segment
    (`../../../../../docs/sql-manual/...`); aligned to the sibling link's
    correct form `../../../../sql-manual/...`.
    - **time-format.md** — a stray closing ``` fence sat at the very end of
    the file (after the Note) with no matching opener; removed.
    - **timestampadd.md** — the second `-- Unit not supported, invalid`
    example actually triggers an out-of-range error, not an unsupported-unit
    error; the comment is updated to match the actual error.
    - **timestampdiff.md** — the Description said *"behaves consistently
    with the [date_diff function] in MySQL"*; the matching MySQL function is
    `TIMESTAMPDIFF`. Function name and URL anchor corrected.
    - **to-days.md / unix-timestamp.md / utc-time.md** — misaligned ASCII
    result-table borders. `utc-time.md` additionally had a top border
    missing its leading `+`.
    - **week-floor.md** — an error label read `RROR 1105 (HY000):` (missing
    the leading `E`); corrected to `ERROR 1105 (HY000):`.
    - **week.md** — the mode-description table was enclosed in a ```sql
    fence and rendered as raw code; the fence is removed so the markdown
    table renders normally (consistent with `yearweek.md`).
    - **week.md / weekday.md / weekofyear.md** — the parameters table key
    was `\`<datetime_or_date>\`` while the Syntax used
    `\`<date_or_time_expr>\``; unified on `\`<date_or_time_expr>\``.
    - **weekofyear.md** — a sentence said "the 1st week of the current year
    starts from the next **Sunday**". The function uses Monday-start weeks
    (mode-3 default), so corrected to "next **Monday**".
    - **year-ceil.md / year-floor.md** — `<period>` description said *"how
    many seconds each period consists of"* / *"Default is 1 second"*
    (copy-paste from the second-ceil docs); corrected to "years" / "1 year".
    - **weeks-sub.md** — error messages echoed `weeks_add` instead of
    `weeks_sub`; corrected.
    - **years-sub.md** — error messages echoed `year_add` instead of
    `years_sub`; corrected.
    - **weeks-diff.md / years-diff.md** — the `null_input1` / `null_input2`
    result tables had rulers one character narrower than the data cells;
    widened.
    - **year-ceil.md / year-floor.md** — the TimeStampTz result tables had
    header rows one character shorter than their rulers; padded.
    
    ### encrypt-digest-functions
    
    - **aes-encrypt.md** — the key-padding paragraph said *"if the key input
    by the user is less than 16 **bits**"*; the unit used elsewhere in the
    same paragraph is bytes (128/8 = 16 bytes). Corrected to "bytes".
    - **aes-decrypt.md / aes-encrypt.md** — frontmatter `description`
    referenced `AESDECRYPT`, `AESENCRYPT`, and `AES128ECB` with no
    underscores; corrected to `AES_DECRYPT`, `AES_ENCRYPT`, and
    `AES_128_ECB`.
    - **murmur-hash3-32.md** — a Note bullet was written as `-Note:` with no
    space after the dash and the sentence ended with a full-width `。`;
    corrected to `- Note:` and an ASCII period.
    
    ## Test plan
    
    - [ ] CI doc build passes
    - [ ] Spot-check the affected pages render correctly (error messages,
    MySQL references, result-table alignment, the `week.md` mode table no
    longer rendered as code, link labels)
---
 .../scalar-functions/date-time-functions/add-time.md     |  2 +-
 .../scalar-functions/date-time-functions/quarters-add.md |  4 ++--
 .../scalar-functions/date-time-functions/sec-to-time.md  |  4 ++--
 .../scalar-functions/date-time-functions/second-ceil.md  |  4 ++--
 .../scalar-functions/date-time-functions/second-floor.md |  4 ++--
 .../scalar-functions/date-time-functions/sub-time.md     |  2 +-
 .../scalar-functions/date-time-functions/timestampadd.md |  2 +-
 .../date-time-functions/timestampdiff.md                 |  2 +-
 .../scalar-functions/date-time-functions/to-days.md      | 16 ++++++++--------
 .../date-time-functions/unix-timestamp.md                |  4 ++--
 .../scalar-functions/date-time-functions/utc-time.md     |  2 +-
 .../scalar-functions/date-time-functions/week-floor.md   |  2 +-
 .../scalar-functions/date-time-functions/week.md         |  5 ++---
 .../scalar-functions/date-time-functions/weekday.md      |  2 +-
 .../scalar-functions/date-time-functions/weekofyear.md   |  4 ++--
 .../scalar-functions/date-time-functions/weeks-diff.md   |  8 ++++----
 .../scalar-functions/date-time-functions/weeks-sub.md    |  4 ++--
 .../scalar-functions/date-time-functions/year-ceil.md    | 12 ++++++------
 .../scalar-functions/date-time-functions/year-floor.md   | 12 ++++++------
 .../scalar-functions/date-time-functions/years-sub.md    |  4 ++--
 .../encrypt-digest-functions/aes-decrypt.md              |  2 +-
 .../encrypt-digest-functions/aes-encrypt.md              |  4 ++--
 .../encrypt-digest-functions/murmur-hash3-32.md          |  2 +-
 .../scalar-functions/date-time-functions/quarters-add.md |  4 ++--
 .../scalar-functions/date-time-functions/utc-time.md     |  2 +-
 .../scalar-functions/date-time-functions/week-floor.md   |  2 +-
 .../scalar-functions/date-time-functions/weeks-add.md    |  4 ++--
 .../scalar-functions/date-time-functions/weeks-diff.md   |  8 ++++----
 .../scalar-functions/date-time-functions/weeks-sub.md    |  4 ++--
 .../scalar-functions/date-time-functions/years-diff.md   |  8 ++++----
 .../scalar-functions/date-time-functions/years-sub.md    |  4 ++--
 .../scalar-functions/date-time-functions/quarters-add.md |  4 ++--
 .../scalar-functions/date-time-functions/utc-time.md     |  2 +-
 .../scalar-functions/date-time-functions/week-floor.md   |  2 +-
 .../scalar-functions/date-time-functions/weeks-add.md    |  4 ++--
 .../scalar-functions/date-time-functions/weeks-diff.md   |  8 ++++----
 .../scalar-functions/date-time-functions/weeks-sub.md    |  4 ++--
 .../scalar-functions/date-time-functions/years-diff.md   |  8 ++++----
 .../scalar-functions/date-time-functions/years-sub.md    |  4 ++--
 .../encrypt-digest-functions/aes-decrypt.md              |  2 +-
 .../encrypt-digest-functions/aes-encrypt.md              |  4 ++--
 .../encrypt-digest-functions/murmur-hash3-32.md          |  2 +-
 .../encrypt-digest-functions/aes-decrypt.md              |  2 +-
 .../encrypt-digest-functions/aes-encrypt.md              |  4 ++--
 .../encrypt-digest-functions/murmur-hash3-32.md          |  2 +-
 .../scalar-functions/date-time-functions/add-time.md     |  2 +-
 .../scalar-functions/date-time-functions/quarters-add.md |  4 ++--
 .../scalar-functions/date-time-functions/sec-to-time.md  |  4 ++--
 .../scalar-functions/date-time-functions/second-ceil.md  |  4 ++--
 .../scalar-functions/date-time-functions/second-floor.md |  4 ++--
 .../scalar-functions/date-time-functions/sub-time.md     |  2 +-
 .../scalar-functions/date-time-functions/timestampadd.md |  2 +-
 .../date-time-functions/timestampdiff.md                 |  2 +-
 .../scalar-functions/date-time-functions/to-days.md      | 16 ++++++++--------
 .../date-time-functions/unix-timestamp.md                |  4 ++--
 .../scalar-functions/date-time-functions/utc-time.md     |  2 +-
 .../scalar-functions/date-time-functions/week-floor.md   |  2 +-
 .../scalar-functions/date-time-functions/week.md         |  5 ++---
 .../scalar-functions/date-time-functions/weekday.md      |  2 +-
 .../scalar-functions/date-time-functions/weekofyear.md   |  4 ++--
 .../scalar-functions/date-time-functions/weeks-diff.md   |  8 ++++----
 .../scalar-functions/date-time-functions/weeks-sub.md    |  4 ++--
 .../scalar-functions/date-time-functions/year-ceil.md    | 12 ++++++------
 .../scalar-functions/date-time-functions/year-floor.md   | 12 ++++++------
 .../scalar-functions/date-time-functions/years-sub.md    |  4 ++--
 .../encrypt-digest-functions/aes-decrypt.md              |  2 +-
 .../encrypt-digest-functions/aes-encrypt.md              |  4 ++--
 .../encrypt-digest-functions/murmur-hash3-32.md          |  2 +-
 68 files changed, 150 insertions(+), 152 deletions(-)

diff --git 
a/docs/sql-manual/sql-functions/scalar-functions/date-time-functions/add-time.md
 
b/docs/sql-manual/sql-functions/scalar-functions/date-time-functions/add-time.md
index 913b7779af5..c03150f8825 100644
--- 
a/docs/sql-manual/sql-functions/scalar-functions/date-time-functions/add-time.md
+++ 
b/docs/sql-manual/sql-functions/scalar-functions/date-time-functions/add-time.md
@@ -20,7 +20,7 @@ ADD_TIME(`<date_or_time_expr>`, `<time>`)
 
 | Parameter             | Description |
 | ---------------------| ----------- |
-| `<date_or_time_expr>`| A valid date expression. Supports input of 
timestamptz/datetime/date/time types. If the type is date, it will be converted 
to the start time of the day (00:00:00). For specific formats, see [timestamptz 
conversion](../../../../sql-manual/basic-element/sql-data-types/conversion/timestamptz-conversion),
 [datetime 
conversion](../../../../../docs/sql-manual/basic-element/sql-data-types/conversion/datetime-conversion)
 and [time conversion](../../../../../docs/sql-manu [...]
+| `<date_or_time_expr>`| A valid date expression. Supports input of 
timestamptz/datetime/date/time types. If the type is date, it will be converted 
to the start time of the day (00:00:00). For specific formats, 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 [time conversion](../../../../sql-manual/basic-element [...]
 | `<time>`             | A valid time expression, representing the time value 
to be added to `<date_or_time_expr>`. If negative, it means subtraction. 
Supports input of time type. |
 
 ## Return Value
diff --git 
a/docs/sql-manual/sql-functions/scalar-functions/date-time-functions/quarters-add.md
 
b/docs/sql-manual/sql-functions/scalar-functions/date-time-functions/quarters-add.md
index 77fd42a35a1..3dd80b22640 100644
--- 
a/docs/sql-manual/sql-functions/scalar-functions/date-time-functions/quarters-add.md
+++ 
b/docs/sql-manual/sql-functions/scalar-functions/date-time-functions/quarters-add.md
@@ -104,8 +104,8 @@ SELECT QUARTERS_ADD('2025-10-10 11:22:33.123+07:00', 1);
 
 --- Calculation result exceeds date range
 SELECT QUARTERS_ADD('9999-10-31', 2) AS result;
-ERROR 1105 (HY000): errCode = 2, detailMessage = (10.16.10.3)[E-218]Operation 
month_add of 9999-10-31, 6 out of range
+ERROR 1105 (HY000): errCode = 2, detailMessage = (10.16.10.3)[E-218]Operation 
quarters_add of 9999-10-31, 6 out of range
 
 SELECT QUARTERS_ADD('0000-01-01',-2) AS result;
-ERROR 1105 (HY000): errCode = 2, detailMessage = (10.16.10.3)[E-218]Operation 
month_add of 0000-01-01, -6 out of range
+ERROR 1105 (HY000): errCode = 2, detailMessage = (10.16.10.3)[E-218]Operation 
quarters_add of 0000-01-01, -6 out of range
 ```
\ No newline at end of file
diff --git 
a/docs/sql-manual/sql-functions/scalar-functions/date-time-functions/sec-to-time.md
 
b/docs/sql-manual/sql-functions/scalar-functions/date-time-functions/sec-to-time.md
index 352824ac201..e30588cdf76 100644
--- 
a/docs/sql-manual/sql-functions/scalar-functions/date-time-functions/sec-to-time.md
+++ 
b/docs/sql-manual/sql-functions/scalar-functions/date-time-functions/sec-to-time.md
@@ -27,7 +27,7 @@ SEC_TO_TIME(<seconds>)
 ## Return Value
 
 Returns a TIME type value converted from seconds.
-- If the input seconds exceed the valid range of TIME type (-838:59:59 to 
838:59:59, corresponding to seconds range -3023999 to 3023999), returns TIME 
max or min value
+- If the input seconds exceed the valid range of TIME type (-838:59:59 to 
838:59:59, corresponding to seconds range -3020399 to 3020399), returns TIME 
max or min value
 - If the input is NULL, returns NULL
 - if the input is an integer, the return format is HH:MM:SS; if the input is a 
floating-point number, the return format is HH:MM:SS.ssssss.
 
@@ -82,7 +82,7 @@ SELECT SEC_TO_TIME(NULL) AS result;
 | NULL   |
 +--------+
 
---- If the input seconds exceed the valid range of TIME type (-838:59:59 to 
838:59:59, corresponding to seconds range -3023999 to 3023999), returns TIME 
max or min value
+--- If the input seconds exceed the valid range of TIME type (-838:59:59 to 
838:59:59, corresponding to seconds range -3020399 to 3020399), returns TIME 
max or min value
  SELECT SEC_TO_TIME(30245000) AS result;
 +-----------+
 | result    |
diff --git 
a/docs/sql-manual/sql-functions/scalar-functions/date-time-functions/second-ceil.md
 
b/docs/sql-manual/sql-functions/scalar-functions/date-time-functions/second-ceil.md
index 484b36acb29..f2d88597143 100644
--- 
a/docs/sql-manual/sql-functions/scalar-functions/date-time-functions/second-ceil.md
+++ 
b/docs/sql-manual/sql-functions/scalar-functions/date-time-functions/second-ceil.md
@@ -31,7 +31,7 @@ SECOND_CEIL(<datetime>[, <period>][, <origin_datetime>])
 
 | Parameter | Description |
 | --------- | ----------- |
-| `<datetime>` | Required. The input datetime value. 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>` | Required. The input datetime value. 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>` | Optional. Indicates how many seconds make up each period. 
Supports positive integer type (INT). Default is 1 second. |
 | `<origin_datetime>` | Optional. The alignment starting point. Supports input 
of datetime type and strings that conform to datetime formats. If not 
specified, defaults to 0001-01-01T00:00:00. |
 
@@ -40,7 +40,7 @@ SECOND_CEIL(<datetime>[, <period>][, <origin_datetime>])
 Returns a value of type TIMESTAMPTZ, DATETIME or DATE. Returns the time value 
after rounding up to the nearest specified second period based on the input 
datetime. The precision of the return value matches the precision of the input 
datetime parameter.
 
 - If the input is TIMESTAMPTZ type, it will first be converted to local_time 
(for example: `2025-12-31 23:59:59+05:00` represents local_time `2026-01-01 
02:59:59` when the session variable is `+08:00`), and then perform SECOND_CEIL 
calculation.
-- If the input time values (`<date_or_time_expr>` and `<period>`) contain both 
TIMESTAMPTZ and DATETIME types, the output is DATETIME type.
+- If the input time values (`<datetime>` and `<period>`) contain both 
TIMESTAMPTZ and DATETIME types, the output is DATETIME type.
 - If `<period>` is a non-positive integer (≤0), returns an error.
 - If any parameter is NULL, returns NULL.
 - When period is not specified, defaults to a 1-second period.
diff --git 
a/docs/sql-manual/sql-functions/scalar-functions/date-time-functions/second-floor.md
 
b/docs/sql-manual/sql-functions/scalar-functions/date-time-functions/second-floor.md
index b3b7cd2b2fb..6d3cd0796a7 100644
--- 
a/docs/sql-manual/sql-functions/scalar-functions/date-time-functions/second-floor.md
+++ 
b/docs/sql-manual/sql-functions/scalar-functions/date-time-functions/second-floor.md
@@ -30,7 +30,7 @@ SECOND_FLOOR(<datetime>[, <period>][, <origin_datetime>])
 
 | Parameter | Description |
 | --------- | ----------- |
-| `<datetime>` | Required. The input datetime value. 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>` | Required. The input datetime value. 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>` | Optional. Indicates how many seconds make up each period. 
Supports positive integer type (INT). Default is 1 second. |
 | `<origin_datetime>` | Optional. The alignment starting point. Supports input 
of datetime type and strings that conform to datetime formats. If not 
specified, defaults to 0001-01-01T00:00:00. |
 
@@ -39,7 +39,7 @@ SECOND_FLOOR(<datetime>[, <period>][, <origin_datetime>])
 Returns a value of type TIMESTAMPTZ, DATETIME or DATE. Returns the time value 
after rounding down to the nearest specified second period based on the input 
datetime. The precision of the return value matches the precision of the input 
datetime parameter.
 
 - If the input is TIMESTAMPTZ type, it will first be converted to local_time 
(for example: `2025-12-31 23:59:59+05:00` represents local_time `2026-01-01 
02:59:59` when the session variable is `+08:00`), and then perform SECOND_FLOOR 
calculation.
-- If the input time values (`<date_or_time_expr>` and `<period>`) contain both 
TIMESTAMPTZ and DATETIME types, the output is DATETIME type.
+- If the input time values (`<datetime>` and `<period>`) contain both 
TIMESTAMPTZ and DATETIME types, the output is DATETIME type.
 - If `<period>` is a non-positive (≤0), returns error.
 - If any parameter is NULL, returns NULL.
 - When period is not specified, defaults to a 1-second period.
diff --git 
a/docs/sql-manual/sql-functions/scalar-functions/date-time-functions/sub-time.md
 
b/docs/sql-manual/sql-functions/scalar-functions/date-time-functions/sub-time.md
index 0ac02a58eee..8d135ca2ca8 100644
--- 
a/docs/sql-manual/sql-functions/scalar-functions/date-time-functions/sub-time.md
+++ 
b/docs/sql-manual/sql-functions/scalar-functions/date-time-functions/sub-time.md
@@ -20,7 +20,7 @@ SUB_TIME(`<date_or_time_expr>`, `<time>`)
 
 | Parameter             | Description |
 | ---------------------| ----------- |
-| `<date_or_time_expr>`| A valid date expression. Supports input of 
timestamptz/datetime/date/time types. If the type is date, it will be converted 
to the start time of the day (00:00:00). For specific formats, see [timestamptz 
conversion](../../../../sql-manual/basic-element/sql-data-types/conversion/timestamptz-conversion),
 [datetime 
conversion](../../../../../docs/sql-manual/basic-element/sql-data-types/conversion/datetime-conversion)
 and [time conversion](../../../../../docs/sql-manu [...]
+| `<date_or_time_expr>`| A valid date expression. Supports input of 
timestamptz/datetime/date/time types. If the type is date, it will be converted 
to the start time of the day (00:00:00). For specific formats, 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 [time conversion](../../../../sql-manual/basic-element [...]
 | `<time>`             | A valid time expression, representing the time value 
to be subtracted from `<date_or_time_expr>`. If negative, it means addition. 
Supports input of time type. |
 
 ## Return Value
diff --git 
a/docs/sql-manual/sql-functions/scalar-functions/date-time-functions/timestampadd.md
 
b/docs/sql-manual/sql-functions/scalar-functions/date-time-functions/timestampadd.md
index 576b19a0c4e..c9df5425b22 100644
--- 
a/docs/sql-manual/sql-functions/scalar-functions/date-time-functions/timestampadd.md
+++ 
b/docs/sql-manual/sql-functions/scalar-functions/date-time-functions/timestampadd.md
@@ -93,7 +93,7 @@ SELECT TIMESTAMPADD(YEAR,NULL, '2023-12-31 23:59:59') AS 
result;
 | NULL   |
 +--------+
 
--- Unit not supported, invalid
+-- Calculation result exceeds datetime range
 SELECT TIMESTAMPADD(YEAR,10000, '2023-12-31 23:59:59') AS result;
 ERROR 1105 (HY000): errCode = 2, detailMessage = (10.16.10.3)[E-218]Operation 
years_add of 2023-12-31 23:59:59, 10000 out of range
 ```
diff --git 
a/docs/sql-manual/sql-functions/scalar-functions/date-time-functions/timestampdiff.md
 
b/docs/sql-manual/sql-functions/scalar-functions/date-time-functions/timestampdiff.md
index 66bfcb30c8f..75d02a573ab 100644
--- 
a/docs/sql-manual/sql-functions/scalar-functions/date-time-functions/timestampdiff.md
+++ 
b/docs/sql-manual/sql-functions/scalar-functions/date-time-functions/timestampdiff.md
@@ -11,7 +11,7 @@
 Same functionality as the [date-diff function](./datediff)
 The TIMESTAMPDIFF function calculates the difference between two datetime 
values and returns the result in a specified time unit. This function supports 
multiple time units (such as seconds, minutes, hours, days, weeks, months, 
years).
 
-This function behaves consistently with the [date_diff 
function](https://dev.mysql.com/doc/refman/8.4/en/date-and-time-functions.html#function_date-diff)
 in MySQL.
+This function behaves consistently with the [timestampdiff 
function](https://dev.mysql.com/doc/refman/8.4/en/date-and-time-functions.html#function_timestampdiff)
 in MySQL.
 
 ## Syntax
 
diff --git 
a/docs/sql-manual/sql-functions/scalar-functions/date-time-functions/to-days.md 
b/docs/sql-manual/sql-functions/scalar-functions/date-time-functions/to-days.md
index 0b2f4cd251d..0d633159c82 100644
--- 
a/docs/sql-manual/sql-functions/scalar-functions/date-time-functions/to-days.md
+++ 
b/docs/sql-manual/sql-functions/scalar-functions/date-time-functions/to-days.md
@@ -39,17 +39,17 @@ select to_days('0000-01-01');
 
 --input date type
 select to_days('2007-10-07');
-+---------------------------------------+
++-----------------------+
 | to_days('2007-10-07') |
-+---------------------------------------+
-|                                733321 |
-+---------------------------------------+
++-----------------------+
+|                733321 |
++-----------------------+
 
 --input datetime type
 select to_days('2007-10-07 10:03:09');
-+------------------------------------------------+
++--------------------------------+
 | to_days('2007-10-07 10:03:09') |
-+------------------------------------------------+
-|                                         733321 |
-+------------------------------------------------+
++--------------------------------+
+|                         733321 |
++--------------------------------+
 ```
diff --git 
a/docs/sql-manual/sql-functions/scalar-functions/date-time-functions/unix-timestamp.md
 
b/docs/sql-manual/sql-functions/scalar-functions/date-time-functions/unix-timestamp.md
index 14425bbbdbd..ed4f5e050e6 100644
--- 
a/docs/sql-manual/sql-functions/scalar-functions/date-time-functions/unix-timestamp.md
+++ 
b/docs/sql-manual/sql-functions/scalar-functions/date-time-functions/unix-timestamp.md
@@ -57,8 +57,8 @@ mysql> select unix_timestamp('1970-01-01 00:00:00');
 +---------------------------------------+
 | unix_timestamp('1970-01-01 00:00:00') |
 +---------------------------------------+
-|                            0 |
-+------------------------------+
+|                                     0 |
++---------------------------------------+
 
 -- Display timestamp of current time
 mysql> select unix_timestamp();
diff --git 
a/docs/sql-manual/sql-functions/scalar-functions/date-time-functions/utc-time.md
 
b/docs/sql-manual/sql-functions/scalar-functions/date-time-functions/utc-time.md
index 399f9dd5d84..6eb4caf0ae0 100644
--- 
a/docs/sql-manual/sql-functions/scalar-functions/date-time-functions/utc-time.md
+++ 
b/docs/sql-manual/sql-functions/scalar-functions/date-time-functions/utc-time.md
@@ -37,7 +37,7 @@ When the input is NULL or the precision is out of range, an 
error will be thrown
 SELECT UTC_TIME(), UTC_TIME() + 1, UTC_TIME(6), UTC_TIME(6) + 1;
 ```
 ```text
-------------+----------------+-----------------+-----------------+
++------------+----------------+-----------------+-----------------+
 | UTC_TIME() | UTC_TIME() + 1 | UTC_TIME(6)     | UTC_TIME(6) + 1 |
 +------------+----------------+-----------------+-----------------+
 | 06:39:01   |    23941000001 | 06:39:01.934119 |     23941934120 |
diff --git 
a/docs/sql-manual/sql-functions/scalar-functions/date-time-functions/week-floor.md
 
b/docs/sql-manual/sql-functions/scalar-functions/date-time-functions/week-floor.md
index 94f1a135fd1..d66bdec7c66 100644
--- 
a/docs/sql-manual/sql-functions/scalar-functions/date-time-functions/week-floor.md
+++ 
b/docs/sql-manual/sql-functions/scalar-functions/date-time-functions/week-floor.md
@@ -117,7 +117,7 @@ SELECT WEEK_FLOOR('2025-12-31 23:59:59+05:00', '2025-12-15 
00:00:00.123');
 
 -- Invalid period, returns error
 SELECT WEEK_FLOOR('2023-07-13', 0) AS result;
-RROR 1105 (HY000): errCode = 2, detailMessage = (10.16.10.3)[E-218]Operation 
week_floor of 2023-07-13 00:00:00, 0 out of range
+ERROR 1105 (HY000): errCode = 2, detailMessage = (10.16.10.3)[E-218]Operation 
week_floor of 2023-07-13 00:00:00, 0 out of range
 
 -- Parameter is NULL
 SELECT WEEK_FLOOR(NULL, 1) AS result;
diff --git 
a/docs/sql-manual/sql-functions/scalar-functions/date-time-functions/week.md 
b/docs/sql-manual/sql-functions/scalar-functions/date-time-functions/week.md
index 38348b3c6b1..d45fe2a6a91 100644
--- a/docs/sql-manual/sql-functions/scalar-functions/date-time-functions/week.md
+++ b/docs/sql-manual/sql-functions/scalar-functions/date-time-functions/week.md
@@ -12,7 +12,6 @@ The WEEK function returns the week number for a specified 
date, with default Mod
 
 The effect of the mode parameter is shown in the following table:
 
-```sql
 |Mode |First day of week |Week number range |Definition of the first week      
               |
 
|:----|:-----------------|:-----------------|:------------------------------------------------|
 |0    |Sunday            |0-53             |The week containing the first 
Sunday of the year |
@@ -23,7 +22,7 @@ The effect of the mode parameter is shown in the following 
table:
 |5    |Monday            |0-53             |The week containing the first 
Monday of the year |
 |6    |Sunday            |1-53             |The first week with 4 or more days 
in this year  |
 |7    |Monday            |1-53             |The week containing the first 
Monday of the year |
-```
+
 
 This function is consistent with the [week 
function](https://dev.mysql.com/doc/refman/8.4/en/date-and-time-functions.html#function_week)
 in MySQL.
 
@@ -37,7 +36,7 @@ WEEK(`<date_or_time_expr>`, `<mode>`)
 
 | Parameter | Description |
 |-----------|-------------|
-| `<datetime_or_date>` | Input datetime value, supports date/datetime types. 
For datetime and date formats, please refer to [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>` | Input datetime value, supports date/datetime types. 
For datetime and date formats, please refer to [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)|
 | `mode` | Specified calculation method for the first week of the year, type 
INT, range 0-7 |
 
 ## Return Value
diff --git 
a/docs/sql-manual/sql-functions/scalar-functions/date-time-functions/weekday.md 
b/docs/sql-manual/sql-functions/scalar-functions/date-time-functions/weekday.md
index 8366b51df7b..cd7f5a6c2e1 100644
--- 
a/docs/sql-manual/sql-functions/scalar-functions/date-time-functions/weekday.md
+++ 
b/docs/sql-manual/sql-functions/scalar-functions/date-time-functions/weekday.md
@@ -32,7 +32,7 @@ WEEKDAY(`<date_or_time_expr>`)
 
 | Parameter | Description |
 |-----------|-------------|
-| `<datetime_or_date>` | Input datetime value, supports date/datetime types. 
For datetime and date formats, please refer to [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>` | Input datetime value, supports date/datetime types. 
For datetime and date formats, please refer to [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)
 |
 
 ## Return Value
 Returns the index corresponding to the weekday of the date, type INT.
diff --git 
a/docs/sql-manual/sql-functions/scalar-functions/date-time-functions/weekofyear.md
 
b/docs/sql-manual/sql-functions/scalar-functions/date-time-functions/weekofyear.md
index 20f67452718..51a56de49f3 100644
--- 
a/docs/sql-manual/sql-functions/scalar-functions/date-time-functions/weekofyear.md
+++ 
b/docs/sql-manual/sql-functions/scalar-functions/date-time-functions/weekofyear.md
@@ -22,13 +22,13 @@ INT WEEKOFYEAR(`<date_or_time_expr>`)
 ## Parameters
 | Parameter | Description |
 |-----------|-------------|
-| `<datetime_or_date>` | Input datetime value, supports date/datetime types. 
For datetime and date formats, please refer to [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>` | Input datetime value, supports date/datetime types. 
For datetime and date formats, please refer to [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)
 |
 
 ## Return Value
 
 Returns INT type week number, range 1-53, representing which week of the year 
the date belongs to.
 
-- If the week containing January 1st has fewer than 4 days in the current year 
(e.g., if January 1st is a Wednesday, that week only has January 1-3 in the 
current year, totaling 3 days), then that week belongs to the previous year, 
and the 1st week of the current year starts from the next Sunday.
+- If the week containing January 1st has fewer than 4 days in the current year 
(e.g., if January 1st is a Wednesday, that week only has January 1-3 in the 
current year, totaling 3 days), then that week belongs to the previous year, 
and the 1st week of the current year starts from the next Monday.
 - When the week at the end of December has fewer than 4 days total, that week 
belongs to the first week of the next year
 - Input NULL returns NULL
 
diff --git 
a/docs/sql-manual/sql-functions/scalar-functions/date-time-functions/weeks-diff.md
 
b/docs/sql-manual/sql-functions/scalar-functions/date-time-functions/weeks-diff.md
index cf7e1fab313..a1878706cb0 100644
--- 
a/docs/sql-manual/sql-functions/scalar-functions/date-time-functions/weeks-diff.md
+++ 
b/docs/sql-manual/sql-functions/scalar-functions/date-time-functions/weeks-diff.md
@@ -104,9 +104,9 @@ SELECT WEEKS_DIFF('2024-01-01', '2023-12-25') AS cross_year;
 SELECT 
   WEEKS_DIFF(NULL, '2023-10-01') AS null_input1,
   WEEKS_DIFF('2023-10-01', NULL) AS null_input2;
-+------------+------------+
++-------------+-------------+
 | null_input1 | null_input2 |
-+------------+------------+
-| NULL       | NULL       |
-+------------+------------+
++-------------+-------------+
+| NULL        | NULL        |
++-------------+-------------+
 ```
\ No newline at end of file
diff --git 
a/docs/sql-manual/sql-functions/scalar-functions/date-time-functions/weeks-sub.md
 
b/docs/sql-manual/sql-functions/scalar-functions/date-time-functions/weeks-sub.md
index 5be4150c070..8e6c452cd33 100644
--- 
a/docs/sql-manual/sql-functions/scalar-functions/date-time-functions/weeks-sub.md
+++ 
b/docs/sql-manual/sql-functions/scalar-functions/date-time-functions/weeks-sub.md
@@ -86,9 +86,9 @@ SELECT WEEKS_SUB('2025-10-10 11:22:33.123+07:00', 1);
 
 -- The calculation result exceeds the lower bound of the datetime range.
 SELECT WEEKS_SUB('0000-01-01', 1);
-ERROR 1105 (HY000): errCode = 2, detailMessage = (10.16.10.3)[E-218]Operation 
weeks_add of 0000-01-01, -1 out of range
+ERROR 1105 (HY000): errCode = 2, detailMessage = (10.16.10.3)[E-218]Operation 
weeks_sub of 0000-01-01, -1 out of range
 
 -- The calculation result exceeds the upper bound of the datetime range.
 SELECT WEEKS_SUB('9999-12-31', -1);
-ERROR 1105 (HY000): errCode = 2, detailMessage = (10.16.10.3)[E-218]Operation 
weeks_add of 9999-12-31, 1 out of range
+ERROR 1105 (HY000): errCode = 2, detailMessage = (10.16.10.3)[E-218]Operation 
weeks_sub of 9999-12-31, 1 out of range
 ```
\ No newline at end of file
diff --git 
a/docs/sql-manual/sql-functions/scalar-functions/date-time-functions/year-ceil.md
 
b/docs/sql-manual/sql-functions/scalar-functions/date-time-functions/year-ceil.md
index 97707fd1969..4a49e0a52d2 100644
--- 
a/docs/sql-manual/sql-functions/scalar-functions/date-time-functions/year-ceil.md
+++ 
b/docs/sql-manual/sql-functions/scalar-functions/date-time-functions/year-ceil.md
@@ -33,7 +33,7 @@ YEAR_CEIL(<date_or_time_expr>, <period>, <origin>)
 | Parameter | Description |
 |-----------|-------------|
 | `<date_or_time_expr>` | The datetime value to round up, supports 
date/datetime/timestamptz types. Date type will be converted to the start time 
00:00:00 of the corresponding date. 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/ [...]
-| `<period>` | Optional, represents how many seconds each period consists of, 
supports positive integer type (INT). Default is 1 second. |
+| `<period>` | Optional, represents how many years each period consists of, 
supports positive integer type (INT). Default is 1 year. |
 | `<origin_datetime>` | Starting point for the interval, supports 
date/datetime types; defaults to 0000-01-01 00:00:00. |
 
 ## Return Value
@@ -128,11 +128,11 @@ SELECT YEAR_CEIL('2023-07-13 22:22:56', 1, '2028-01-01 
08:30:00') AS result;
 -- TimeStampTz sample, SET time_zone = '+08:00'
 -- Convert to local_time (2026-01-01 02:59:59) and then perform YEAR_CEIL
 SELECT YEAR_CEIL('2025-12-31 23:59:59+05:00');
-+---------------------------------------+
-| YEAR_CEIL('2025-12-31 23:59:59+05:00')|
-+---------------------------------------+
-| 2027-01-01 00:00:00+08:00             |
-+---------------------------------------+
++----------------------------------------+
+| YEAR_CEIL('2025-12-31 23:59:59+05:00') |
++----------------------------------------+
+| 2027-01-01 00:00:00+08:00              |
++----------------------------------------+
 
 -- If parameters contain both TimeStampTz and Datetime types, output DateTime 
type
 SELECT YEAR_CEIL('2025-12-31 23:59:59+05:00', '2025-12-15 00:00:00.123');
diff --git 
a/docs/sql-manual/sql-functions/scalar-functions/date-time-functions/year-floor.md
 
b/docs/sql-manual/sql-functions/scalar-functions/date-time-functions/year-floor.md
index 145e3f9ecf7..4c2cf738f29 100644
--- 
a/docs/sql-manual/sql-functions/scalar-functions/date-time-functions/year-floor.md
+++ 
b/docs/sql-manual/sql-functions/scalar-functions/date-time-functions/year-floor.md
@@ -32,7 +32,7 @@ YEAR_FLOOR(<date_or_time_expr>, <period>, <origin>)
 | Parameter | Description |
 |-----------|-------------|
 | `<date_or_time_expr>` | The datetime value to round down, supports 
date/datetime/timestamptz types. Date type will be converted to the start time 
00:00:00 of the corresponding date. 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-elemen [...]
-| `<period>` | Optional, represents how many seconds each period consists of, 
supports positive integer type (INT). Default is 1 second. |
+| `<period>` | Optional, represents how many years each period consists of, 
supports positive integer type (INT). Default is 1 year. |
 | `<origin_datetime>` | Starting point for the interval, supports 
date/datetime types; defaults to 0000-01-01 00:00:00. |
 
 ## Return Value
@@ -157,11 +157,11 @@ SELECT YEAR_FLOOR('2023-07-13 10:00:00', 1, '2020-01-01 
08:30:00') AS result;
 -- TimeStampTz sample, SET time_zone = '+08:00'
 -- Convert to local_time (2026-01-01 02:59:59) and then perform YEAR_FLOOR
 SELECT YEAR_FLOOR('2025-12-31 23:59:59+05:00');
-+----------------------------------------+
-| YEAR_FLOOR('2025-12-31 23:59:59+05:00')|
-+----------------------------------------+
-| 2026-01-01 00:00:00+08:00              |
-+----------------------------------------+
++-----------------------------------------+
+| YEAR_FLOOR('2025-12-31 23:59:59+05:00') |
++-----------------------------------------+
+| 2026-01-01 00:00:00+08:00               |
++-----------------------------------------+
 
 -- If parameters contain both TimeStampTz and Datetime types, output DateTime 
type
 SELECT YEAR_FLOOR('2025-12-31 23:59:59+05:00', '2025-12-15 00:00:00.123');
diff --git 
a/docs/sql-manual/sql-functions/scalar-functions/date-time-functions/years-sub.md
 
b/docs/sql-manual/sql-functions/scalar-functions/date-time-functions/years-sub.md
index 66a19eb5e2a..e79e5e7a874 100644
--- 
a/docs/sql-manual/sql-functions/scalar-functions/date-time-functions/years-sub.md
+++ 
b/docs/sql-manual/sql-functions/scalar-functions/date-time-functions/years-sub.md
@@ -90,9 +90,9 @@ SELECT YEARS_SUB('2025-10-10 11:22:33.123+07:00', 1);
 
 -- Calculation result exceeds datetime range (upper limit)
 SELECT YEARS_SUB('9999-12-31', -1);
-ERROR 1105 (HY000): errCode = 2, detailMessage = (10.16.10.3)[E-218]Operation 
year_add of 9999-12-31, 1 out of range
+ERROR 1105 (HY000): errCode = 2, detailMessage = (10.16.10.3)[E-218]Operation 
years_sub of 9999-12-31, 1 out of range
 
 -- Calculation result exceeds datetime range (lower limit)
 SELECT YEARS_SUB('0000-01-01', 1);
-ERROR 1105 (HY000): errCode = 2, detailMessage = (10.16.10.3)[E-218]Operation 
year_add of 0000-01-01, -1 out of range
+ERROR 1105 (HY000): errCode = 2, detailMessage = (10.16.10.3)[E-218]Operation 
years_sub of 0000-01-01, -1 out of range
 ```
diff --git 
a/docs/sql-manual/sql-functions/scalar-functions/encrypt-digest-functions/aes-decrypt.md
 
b/docs/sql-manual/sql-functions/scalar-functions/encrypt-digest-functions/aes-decrypt.md
index 43eeb4b6104..04a3179aad0 100644
--- 
a/docs/sql-manual/sql-functions/scalar-functions/encrypt-digest-functions/aes-decrypt.md
+++ 
b/docs/sql-manual/sql-functions/scalar-functions/encrypt-digest-functions/aes-decrypt.md
@@ -2,7 +2,7 @@
 {
     "title": "AES_DECRYPT",
     "language": "en",
-    "description": "AES decryption function. This function behaves the same as 
the AESDECRYPT function in MySQL. The default algorithm is AES128ECB,"
+    "description": "AES decryption function. This function behaves the same as 
the AES_DECRYPT function in MySQL. The default algorithm is AES_128_ECB,"
 }
 ---
 
diff --git 
a/docs/sql-manual/sql-functions/scalar-functions/encrypt-digest-functions/aes-encrypt.md
 
b/docs/sql-manual/sql-functions/scalar-functions/encrypt-digest-functions/aes-encrypt.md
index 3dfd3df2d4f..3c54beefff8 100644
--- 
a/docs/sql-manual/sql-functions/scalar-functions/encrypt-digest-functions/aes-encrypt.md
+++ 
b/docs/sql-manual/sql-functions/scalar-functions/encrypt-digest-functions/aes-encrypt.md
@@ -2,7 +2,7 @@
 {
     "title": "AES_ENCRYPT",
     "language": "en",
-    "description": "AES encryption function. This function behaves the same as 
the AESENCRYPT function in MySQL. The default algorithm is AES128ECB,"
+    "description": "AES encryption function. This function behaves the same as 
the AES_ENCRYPT function in MySQL. The default algorithm is AES_128_ECB,"
 }
 ---
 
@@ -12,7 +12,7 @@ AES encryption function. This function behaves the same as 
the `AES_ENCRYPT` fun
 
 The AES_ENCRYPT function does not use the passed key directly, but further 
processes it. The specific steps are as follows:
 1. Determine the number of bytes of the key according to the encryption 
algorithm used. For example, if the AES_128_ECB algorithm is used, the number 
of bytes of the key is `128 / 8 = 16` (if the AES_256_ECB algorithm is used, 
the number of bytes of the key is `256 / 8 = 32`);
-2. Then, for the key input by the user, the `i`th bit and the `16*k+i`th bit 
are XORed. If the key input by the user is less than 16 bits, 0 is added at the 
end.
+2. Then, for the key input by the user, the `i`th byte and the `16*k+i`th byte 
are XORed. If the key input by the user is less than 16 bytes, 0 is added at 
the end.
 3. Finally, use the newly generated key to encrypt;
 
 ## Syntax
diff --git 
a/docs/sql-manual/sql-functions/scalar-functions/encrypt-digest-functions/murmur-hash3-32.md
 
b/docs/sql-manual/sql-functions/scalar-functions/encrypt-digest-functions/murmur-hash3-32.md
index 2cfcf4c3164..6bc8f51ee9b 100644
--- 
a/docs/sql-manual/sql-functions/scalar-functions/encrypt-digest-functions/murmur-hash3-32.md
+++ 
b/docs/sql-manual/sql-functions/scalar-functions/encrypt-digest-functions/murmur-hash3-32.md
@@ -10,7 +10,7 @@
 
 Calculate 32-bit murmur3 hash value
 
--Note: When calculating hash values, it is recommended to use `xxhash_32` 
instead of `murmur_hash3_32`。
+- Note: When calculating hash values, it is recommended to use `xxhash_32` 
instead of `murmur_hash3_32`.
 
 ## Syntax
 
diff --git 
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/date-time-functions/quarters-add.md
 
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/date-time-functions/quarters-add.md
index 8767afbe445..ef3bd3b5e87 100644
--- 
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/date-time-functions/quarters-add.md
+++ 
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/date-time-functions/quarters-add.md
@@ -102,8 +102,8 @@ SELECT QUARTERS_ADD('2025-10-10 11:22:33.123+07:00', 1);
 
 --- 计算结果超出日期范围
 SELECT QUARTERS_ADD('9999-10-31', 2) AS result;
-ERROR 1105 (HY000): errCode = 2, detailMessage = (10.16.10.3)[E-218]Operation 
month_add of 9999-10-31, 6 out of range
+ERROR 1105 (HY000): errCode = 2, detailMessage = (10.16.10.3)[E-218]Operation 
quarters_add of 9999-10-31, 6 out of range
 
 SELECT QUARTERS_ADD('0000-01-01',-2) AS result;
-ERROR 1105 (HY000): errCode = 2, detailMessage = (10.16.10.3)[E-218]Operation 
month_add of 0000-01-01, -6 out of range
+ERROR 1105 (HY000): errCode = 2, detailMessage = (10.16.10.3)[E-218]Operation 
quarters_add of 0000-01-01, -6 out of range
 ```
\ No newline at end of file
diff --git 
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/date-time-functions/utc-time.md
 
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/date-time-functions/utc-time.md
index 13541087aad..c811c78a84f 100644
--- 
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/date-time-functions/utc-time.md
+++ 
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/date-time-functions/utc-time.md
@@ -38,7 +38,7 @@ UTC_TIME([<`precision`>])
 SELECT UTC_TIME(), UTC_TIME() + 1, UTC_TIME(6), UTC_TIME(6) + 1;
 ```
 ```text
-------------+----------------+-----------------+-----------------+
++------------+----------------+-----------------+-----------------+
 | UTC_TIME() | UTC_TIME() + 1 | UTC_TIME(6)     | UTC_TIME(6) + 1 |
 +------------+----------------+-----------------+-----------------+
 | 06:39:01   |    23941000001 | 06:39:01.934119 |     23941934120 |
diff --git 
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/date-time-functions/week-floor.md
 
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/date-time-functions/week-floor.md
index adc7adeb7e2..fd1e9d06cca 100644
--- 
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/date-time-functions/week-floor.md
+++ 
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/date-time-functions/week-floor.md
@@ -148,7 +148,7 @@ SELECT WEEK_FLOOR('2025-12-31 23:59:59+05:00', '2025-12-15 
00:00:00.123');
 
 -- 无效period，返回错误
 SELECT WEEK_FLOOR('2023-07-13', 0) AS result;
-RROR 1105 (HY000): errCode = 2, detailMessage = (10.16.10.3)[E-218]Operation 
week_floor of 2023-07-13 00:00:00, 0 out of range
+ERROR 1105 (HY000): errCode = 2, detailMessage = (10.16.10.3)[E-218]Operation 
week_floor of 2023-07-13 00:00:00, 0 out of range
 
 -- 参数为NULL
 SELECT WEEK_FLOOR(NULL, 1) AS result;
diff --git 
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/date-time-functions/weeks-add.md
 
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/date-time-functions/weeks-add.md
index 853de3a75b5..909c9300197 100644
--- 
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/date-time-functions/weeks-add.md
+++ 
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/date-time-functions/weeks-add.md
@@ -89,8 +89,8 @@ SELECT WEEKS_ADD('2025-10-10 11:22:33.123+07:00', 1);
 
 ---计算结果超出日期时间范围
 SELECT WEEKS_ADD('9999-12-31',1);
-ERROR 1105 (HY000): errCode = 2, detailMessage = (10.16.10.3)[E-218]Operation 
weeks_add of 9999-12-31, 1 out of range
+ERROR 1105 (HY000): errCode = 2, detailMessage = (10.16.10.3)[E-218]Operation 
weeks_sub of 9999-12-31, 1 out of range
 
 SELECT WEEKS_ADD('0000-01-01',-1);
-ERROR 1105 (HY000): errCode = 2, detailMessage = (10.16.10.3)[E-218]Operation 
weeks_add of 0000-01-01, -1 out of range
+ERROR 1105 (HY000): errCode = 2, detailMessage = (10.16.10.3)[E-218]Operation 
weeks_sub of 0000-01-01, -1 out of range
 ```
\ No newline at end of file
diff --git 
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/date-time-functions/weeks-diff.md
 
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/date-time-functions/weeks-diff.md
index 8ca53a125be..23c082fbd36 100644
--- 
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/date-time-functions/weeks-diff.md
+++ 
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/date-time-functions/weeks-diff.md
@@ -104,9 +104,9 @@ SELECT WEEKS_DIFF('2024-01-01', '2023-12-25') AS cross_year;
 SELECT 
   WEEKS_DIFF(NULL, '2023-10-01') AS null_input1,
   WEEKS_DIFF('2023-10-01', NULL) AS null_input2;
-+------------+------------+
++-------------+-------------+
 | null_input1 | null_input2 |
-+------------+------------+
-| NULL       | NULL       |
-+------------+------------+
++-------------+-------------+
+| NULL        | NULL        |
++-------------+-------------+
 ```
\ No newline at end of file
diff --git 
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/date-time-functions/weeks-sub.md
 
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/date-time-functions/weeks-sub.md
index 07ca3223d91..e68c95ea631 100644
--- 
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/date-time-functions/weeks-sub.md
+++ 
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/date-time-functions/weeks-sub.md
@@ -86,9 +86,9 @@ SELECT WEEKS_SUB('2025-10-10 11:22:33.123+07:00', 1);
 
 -- 计算结果超出日期时间范围（下限）
 SELECT WEEKS_SUB('0000-01-01', 1);
-ERROR 1105 (HY000): errCode = 2, detailMessage = (10.16.10.3)[E-218]Operation 
weeks_add of 0000-01-01, -1 out of range
+ERROR 1105 (HY000): errCode = 2, detailMessage = (10.16.10.3)[E-218]Operation 
weeks_sub of 0000-01-01, -1 out of range
 
 -- 计算结果超出日期时间范围（上限）
 SELECT WEEKS_SUB('9999-12-31', -1);
-ERROR 1105 (HY000): errCode = 2, detailMessage = (10.16.10.3)[E-218]Operation 
weeks_add of 9999-12-31, 1 out of range
+ERROR 1105 (HY000): errCode = 2, detailMessage = (10.16.10.3)[E-218]Operation 
weeks_sub of 9999-12-31, 1 out of range
 ```
\ No newline at end of file
diff --git 
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/date-time-functions/years-diff.md
 
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/date-time-functions/years-diff.md
index 5da2d286150..20ecf94784f 100644
--- 
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/date-time-functions/years-diff.md
+++ 
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/date-time-functions/years-diff.md
@@ -87,9 +87,9 @@ SELECT YEARS_DIFF('2024-02-29', '2023-02-28') AS 
leap_year_diff;
 SELECT 
   YEARS_DIFF(NULL, '2023-03-15') AS null_input1,
   YEARS_DIFF('2023-03-15', NULL) AS null_input2;
-+------------+------------+
++-------------+-------------+
 | null_input1 | null_input2 |
-+------------+------------+
-| NULL       | NULL       |
-+------------+------------+
++-------------+-------------+
+| NULL        | NULL        |
++-------------+-------------+
 ```
diff --git 
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/date-time-functions/years-sub.md
 
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/date-time-functions/years-sub.md
index 4cee1553528..105a30cf9e1 100644
--- 
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/date-time-functions/years-sub.md
+++ 
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/date-time-functions/years-sub.md
@@ -89,8 +89,8 @@ SELECT YEARS_SUB('2025-10-10 11:22:33.123+07:00', 1);
 
 -- 计算结果超出日期时间范围（上限）
 SELECT YEARS_SUB('9999-12-31', -1);
-ERROR 1105 (HY000): errCode = 2, detailMessage = (10.16.10.3)[E-218]Operation 
year_add of 9999-12-31, 1 out of range
+ERROR 1105 (HY000): errCode = 2, detailMessage = (10.16.10.3)[E-218]Operation 
years_sub of 9999-12-31, 1 out of range
 
 --计算结果超出日期时间范围（下限）
 SELECT YEARS_SUB('0000-01-01', 1);
-ERROR 1105 (HY000): errCode = 2, detailMessage = (10.16.10.3)[E-218]Operation 
year_add of 0000-01-01, -1 out of range
+ERROR 1105 (HY000): errCode = 2, detailMessage = (10.16.10.3)[E-218]Operation 
years_sub of 0000-01-01, -1 out of range
diff --git 
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/scalar-functions/date-time-functions/quarters-add.md
 
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/scalar-functions/date-time-functions/quarters-add.md
index 8767afbe445..ef3bd3b5e87 100644
--- 
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/scalar-functions/date-time-functions/quarters-add.md
+++ 
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/scalar-functions/date-time-functions/quarters-add.md
@@ -102,8 +102,8 @@ SELECT QUARTERS_ADD('2025-10-10 11:22:33.123+07:00', 1);
 
 --- 计算结果超出日期范围
 SELECT QUARTERS_ADD('9999-10-31', 2) AS result;
-ERROR 1105 (HY000): errCode = 2, detailMessage = (10.16.10.3)[E-218]Operation 
month_add of 9999-10-31, 6 out of range
+ERROR 1105 (HY000): errCode = 2, detailMessage = (10.16.10.3)[E-218]Operation 
quarters_add of 9999-10-31, 6 out of range
 
 SELECT QUARTERS_ADD('0000-01-01',-2) AS result;
-ERROR 1105 (HY000): errCode = 2, detailMessage = (10.16.10.3)[E-218]Operation 
month_add of 0000-01-01, -6 out of range
+ERROR 1105 (HY000): errCode = 2, detailMessage = (10.16.10.3)[E-218]Operation 
quarters_add of 0000-01-01, -6 out of range
 ```
\ No newline at end of file
diff --git 
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/scalar-functions/date-time-functions/utc-time.md
 
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/scalar-functions/date-time-functions/utc-time.md
index 13541087aad..c811c78a84f 100644
--- 
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/scalar-functions/date-time-functions/utc-time.md
+++ 
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/scalar-functions/date-time-functions/utc-time.md
@@ -38,7 +38,7 @@ UTC_TIME([<`precision`>])
 SELECT UTC_TIME(), UTC_TIME() + 1, UTC_TIME(6), UTC_TIME(6) + 1;
 ```
 ```text
-------------+----------------+-----------------+-----------------+
++------------+----------------+-----------------+-----------------+
 | UTC_TIME() | UTC_TIME() + 1 | UTC_TIME(6)     | UTC_TIME(6) + 1 |
 +------------+----------------+-----------------+-----------------+
 | 06:39:01   |    23941000001 | 06:39:01.934119 |     23941934120 |
diff --git 
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/scalar-functions/date-time-functions/week-floor.md
 
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/scalar-functions/date-time-functions/week-floor.md
index adc7adeb7e2..fd1e9d06cca 100644
--- 
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/scalar-functions/date-time-functions/week-floor.md
+++ 
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/scalar-functions/date-time-functions/week-floor.md
@@ -148,7 +148,7 @@ SELECT WEEK_FLOOR('2025-12-31 23:59:59+05:00', '2025-12-15 
00:00:00.123');
 
 -- 无效period，返回错误
 SELECT WEEK_FLOOR('2023-07-13', 0) AS result;
-RROR 1105 (HY000): errCode = 2, detailMessage = (10.16.10.3)[E-218]Operation 
week_floor of 2023-07-13 00:00:00, 0 out of range
+ERROR 1105 (HY000): errCode = 2, detailMessage = (10.16.10.3)[E-218]Operation 
week_floor of 2023-07-13 00:00:00, 0 out of range
 
 -- 参数为NULL
 SELECT WEEK_FLOOR(NULL, 1) AS result;
diff --git 
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/scalar-functions/date-time-functions/weeks-add.md
 
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/scalar-functions/date-time-functions/weeks-add.md
index 853de3a75b5..909c9300197 100644
--- 
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/scalar-functions/date-time-functions/weeks-add.md
+++ 
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/scalar-functions/date-time-functions/weeks-add.md
@@ -89,8 +89,8 @@ SELECT WEEKS_ADD('2025-10-10 11:22:33.123+07:00', 1);
 
 ---计算结果超出日期时间范围
 SELECT WEEKS_ADD('9999-12-31',1);
-ERROR 1105 (HY000): errCode = 2, detailMessage = (10.16.10.3)[E-218]Operation 
weeks_add of 9999-12-31, 1 out of range
+ERROR 1105 (HY000): errCode = 2, detailMessage = (10.16.10.3)[E-218]Operation 
weeks_sub of 9999-12-31, 1 out of range
 
 SELECT WEEKS_ADD('0000-01-01',-1);
-ERROR 1105 (HY000): errCode = 2, detailMessage = (10.16.10.3)[E-218]Operation 
weeks_add of 0000-01-01, -1 out of range
+ERROR 1105 (HY000): errCode = 2, detailMessage = (10.16.10.3)[E-218]Operation 
weeks_sub of 0000-01-01, -1 out of range
 ```
\ No newline at end of file
diff --git 
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/scalar-functions/date-time-functions/weeks-diff.md
 
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/scalar-functions/date-time-functions/weeks-diff.md
index 8ca53a125be..23c082fbd36 100644
--- 
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/scalar-functions/date-time-functions/weeks-diff.md
+++ 
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/scalar-functions/date-time-functions/weeks-diff.md
@@ -104,9 +104,9 @@ SELECT WEEKS_DIFF('2024-01-01', '2023-12-25') AS cross_year;
 SELECT 
   WEEKS_DIFF(NULL, '2023-10-01') AS null_input1,
   WEEKS_DIFF('2023-10-01', NULL) AS null_input2;
-+------------+------------+
++-------------+-------------+
 | null_input1 | null_input2 |
-+------------+------------+
-| NULL       | NULL       |
-+------------+------------+
++-------------+-------------+
+| NULL        | NULL        |
++-------------+-------------+
 ```
\ No newline at end of file
diff --git 
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/scalar-functions/date-time-functions/weeks-sub.md
 
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/scalar-functions/date-time-functions/weeks-sub.md
index 07ca3223d91..e68c95ea631 100644
--- 
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/scalar-functions/date-time-functions/weeks-sub.md
+++ 
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/scalar-functions/date-time-functions/weeks-sub.md
@@ -86,9 +86,9 @@ SELECT WEEKS_SUB('2025-10-10 11:22:33.123+07:00', 1);
 
 -- 计算结果超出日期时间范围（下限）
 SELECT WEEKS_SUB('0000-01-01', 1);
-ERROR 1105 (HY000): errCode = 2, detailMessage = (10.16.10.3)[E-218]Operation 
weeks_add of 0000-01-01, -1 out of range
+ERROR 1105 (HY000): errCode = 2, detailMessage = (10.16.10.3)[E-218]Operation 
weeks_sub of 0000-01-01, -1 out of range
 
 -- 计算结果超出日期时间范围（上限）
 SELECT WEEKS_SUB('9999-12-31', -1);
-ERROR 1105 (HY000): errCode = 2, detailMessage = (10.16.10.3)[E-218]Operation 
weeks_add of 9999-12-31, 1 out of range
+ERROR 1105 (HY000): errCode = 2, detailMessage = (10.16.10.3)[E-218]Operation 
weeks_sub of 9999-12-31, 1 out of range
 ```
\ No newline at end of file
diff --git 
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/scalar-functions/date-time-functions/years-diff.md
 
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/scalar-functions/date-time-functions/years-diff.md
index 5da2d286150..20ecf94784f 100644
--- 
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/scalar-functions/date-time-functions/years-diff.md
+++ 
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/scalar-functions/date-time-functions/years-diff.md
@@ -87,9 +87,9 @@ SELECT YEARS_DIFF('2024-02-29', '2023-02-28') AS 
leap_year_diff;
 SELECT 
   YEARS_DIFF(NULL, '2023-03-15') AS null_input1,
   YEARS_DIFF('2023-03-15', NULL) AS null_input2;
-+------------+------------+
++-------------+-------------+
 | null_input1 | null_input2 |
-+------------+------------+
-| NULL       | NULL       |
-+------------+------------+
++-------------+-------------+
+| NULL        | NULL        |
++-------------+-------------+
 ```
diff --git 
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/scalar-functions/date-time-functions/years-sub.md
 
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/scalar-functions/date-time-functions/years-sub.md
index 4cee1553528..105a30cf9e1 100644
--- 
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/scalar-functions/date-time-functions/years-sub.md
+++ 
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/scalar-functions/date-time-functions/years-sub.md
@@ -89,8 +89,8 @@ SELECT YEARS_SUB('2025-10-10 11:22:33.123+07:00', 1);
 
 -- 计算结果超出日期时间范围（上限）
 SELECT YEARS_SUB('9999-12-31', -1);
-ERROR 1105 (HY000): errCode = 2, detailMessage = (10.16.10.3)[E-218]Operation 
year_add of 9999-12-31, 1 out of range
+ERROR 1105 (HY000): errCode = 2, detailMessage = (10.16.10.3)[E-218]Operation 
years_sub of 9999-12-31, 1 out of range
 
 --计算结果超出日期时间范围（下限）
 SELECT YEARS_SUB('0000-01-01', 1);
-ERROR 1105 (HY000): errCode = 2, detailMessage = (10.16.10.3)[E-218]Operation 
year_add of 0000-01-01, -1 out of range
+ERROR 1105 (HY000): errCode = 2, detailMessage = (10.16.10.3)[E-218]Operation 
years_sub of 0000-01-01, -1 out of range
diff --git 
a/versioned_docs/version-2.1/sql-manual/sql-functions/scalar-functions/encrypt-digest-functions/aes-decrypt.md
 
b/versioned_docs/version-2.1/sql-manual/sql-functions/scalar-functions/encrypt-digest-functions/aes-decrypt.md
index 03765b3da29..71bbd4b4df0 100644
--- 
a/versioned_docs/version-2.1/sql-manual/sql-functions/scalar-functions/encrypt-digest-functions/aes-decrypt.md
+++ 
b/versioned_docs/version-2.1/sql-manual/sql-functions/scalar-functions/encrypt-digest-functions/aes-decrypt.md
@@ -2,7 +2,7 @@
 {
     "title": "AES_DECRYPT",
     "language": "en",
-    "description": "AES decryption function. This function behaves the same as 
the AESDECRYPT function in MySQL. The default algorithm is AES128ECB,"
+    "description": "AES decryption function. This function behaves the same as 
the AES_DECRYPT function in MySQL. The default algorithm is AES_128_ECB,"
 }
 ---
 
diff --git 
a/versioned_docs/version-2.1/sql-manual/sql-functions/scalar-functions/encrypt-digest-functions/aes-encrypt.md
 
b/versioned_docs/version-2.1/sql-manual/sql-functions/scalar-functions/encrypt-digest-functions/aes-encrypt.md
index ce43ed3678e..ade17780f86 100644
--- 
a/versioned_docs/version-2.1/sql-manual/sql-functions/scalar-functions/encrypt-digest-functions/aes-encrypt.md
+++ 
b/versioned_docs/version-2.1/sql-manual/sql-functions/scalar-functions/encrypt-digest-functions/aes-encrypt.md
@@ -2,7 +2,7 @@
 {
     "title": "AES_ENCRYPT",
     "language": "en",
-    "description": "AES encryption function. This function behaves the same as 
the AESENCRYPT function in MySQL. The default algorithm is AES128ECB,"
+    "description": "AES encryption function. This function behaves the same as 
the AES_ENCRYPT function in MySQL. The default algorithm is AES_128_ECB,"
 }
 ---
 
@@ -13,7 +13,7 @@ AES encryption function. This function behaves the same as 
the `AES_ENCRYPT` fun
 The AES_ENCRYPT function does not use the passed key directly, but further 
processes it. The specific steps are as follows:
 
 1. Determine the number of bytes of the key according to the encryption 
algorithm used. For example, if the AES_128_ECB algorithm is used, the number 
of bytes of the key is `128 / 8 = 16` (if the AES_256_ECB algorithm is used, 
the number of bytes of the key is `256 / 8 = 32`);
-2. Then, for the key input by the user, the `i`th bit and the `16*k+i`th bit 
are XORed. If the key input by the user is less than 16 bits, 0 is added at the 
end.
+2. Then, for the key input by the user, the `i`th byte and the `16*k+i`th byte 
are XORed. If the key input by the user is less than 16 bytes, 0 is added at 
the end.
 3. Finally, use the newly generated key to encrypt;
 
 :::warning
diff --git 
a/versioned_docs/version-2.1/sql-manual/sql-functions/scalar-functions/encrypt-digest-functions/murmur-hash3-32.md
 
b/versioned_docs/version-2.1/sql-manual/sql-functions/scalar-functions/encrypt-digest-functions/murmur-hash3-32.md
index 2cfcf4c3164..6bc8f51ee9b 100644
--- 
a/versioned_docs/version-2.1/sql-manual/sql-functions/scalar-functions/encrypt-digest-functions/murmur-hash3-32.md
+++ 
b/versioned_docs/version-2.1/sql-manual/sql-functions/scalar-functions/encrypt-digest-functions/murmur-hash3-32.md
@@ -10,7 +10,7 @@
 
 Calculate 32-bit murmur3 hash value
 
--Note: When calculating hash values, it is recommended to use `xxhash_32` 
instead of `murmur_hash3_32`。
+- Note: When calculating hash values, it is recommended to use `xxhash_32` 
instead of `murmur_hash3_32`.
 
 ## Syntax
 
diff --git 
a/versioned_docs/version-3.x/sql-manual/sql-functions/scalar-functions/encrypt-digest-functions/aes-decrypt.md
 
b/versioned_docs/version-3.x/sql-manual/sql-functions/scalar-functions/encrypt-digest-functions/aes-decrypt.md
index 8151ba5bf70..6d4fc250c59 100644
--- 
a/versioned_docs/version-3.x/sql-manual/sql-functions/scalar-functions/encrypt-digest-functions/aes-decrypt.md
+++ 
b/versioned_docs/version-3.x/sql-manual/sql-functions/scalar-functions/encrypt-digest-functions/aes-decrypt.md
@@ -2,7 +2,7 @@
 {
     "title": "AES_DECRYPT",
     "language": "en",
-    "description": "AES decryption function. This function behaves the same as 
the AESDECRYPT function in MySQL. The default algorithm is AES128ECB,"
+    "description": "AES decryption function. This function behaves the same as 
the AES_DECRYPT function in MySQL. The default algorithm is AES_128_ECB,"
 }
 ---
 
diff --git 
a/versioned_docs/version-3.x/sql-manual/sql-functions/scalar-functions/encrypt-digest-functions/aes-encrypt.md
 
b/versioned_docs/version-3.x/sql-manual/sql-functions/scalar-functions/encrypt-digest-functions/aes-encrypt.md
index 32d79804775..89d3ddc34e1 100644
--- 
a/versioned_docs/version-3.x/sql-manual/sql-functions/scalar-functions/encrypt-digest-functions/aes-encrypt.md
+++ 
b/versioned_docs/version-3.x/sql-manual/sql-functions/scalar-functions/encrypt-digest-functions/aes-encrypt.md
@@ -2,7 +2,7 @@
 {
     "title": "AES_ENCRYPT",
     "language": "en",
-    "description": "AES encryption function. This function behaves the same as 
the AESENCRYPT function in MySQL. The default algorithm is AES128ECB,"
+    "description": "AES encryption function. This function behaves the same as 
the AES_ENCRYPT function in MySQL. The default algorithm is AES_128_ECB,"
 }
 ---
 
@@ -13,7 +13,7 @@ AES encryption function. This function behaves the same as 
the `AES_ENCRYPT` fun
 The AES_ENCRYPT function does not use the passed key directly, but further 
processes it. The specific steps are as follows:
 
 1. Determine the number of bytes of the key according to the encryption 
algorithm used. For example, if the AES_128_ECB algorithm is used, the number 
of bytes of the key is `128 / 8 = 16` (if the AES_256_ECB algorithm is used, 
the number of bytes of the key is `256 / 8 = 32`);
-2. Then, for the key input by the user, the `i`th bit and the `16*k+i`th bit 
are XORed. If the key input by the user is less than 16 bits, 0 is added at the 
end.
+2. Then, for the key input by the user, the `i`th byte and the `16*k+i`th byte 
are XORed. If the key input by the user is less than 16 bytes, 0 is added at 
the end.
 3. Finally, use the newly generated key to encrypt;
 
 :::warning
diff --git 
a/versioned_docs/version-3.x/sql-manual/sql-functions/scalar-functions/encrypt-digest-functions/murmur-hash3-32.md
 
b/versioned_docs/version-3.x/sql-manual/sql-functions/scalar-functions/encrypt-digest-functions/murmur-hash3-32.md
index 2cfcf4c3164..6bc8f51ee9b 100644
--- 
a/versioned_docs/version-3.x/sql-manual/sql-functions/scalar-functions/encrypt-digest-functions/murmur-hash3-32.md
+++ 
b/versioned_docs/version-3.x/sql-manual/sql-functions/scalar-functions/encrypt-digest-functions/murmur-hash3-32.md
@@ -10,7 +10,7 @@
 
 Calculate 32-bit murmur3 hash value
 
--Note: When calculating hash values, it is recommended to use `xxhash_32` 
instead of `murmur_hash3_32`。
+- Note: When calculating hash values, it is recommended to use `xxhash_32` 
instead of `murmur_hash3_32`.
 
 ## Syntax
 
diff --git 
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/date-time-functions/add-time.md
 
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/date-time-functions/add-time.md
index 913b7779af5..c03150f8825 100644
--- 
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/date-time-functions/add-time.md
+++ 
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/date-time-functions/add-time.md
@@ -20,7 +20,7 @@ ADD_TIME(`<date_or_time_expr>`, `<time>`)
 
 | Parameter             | Description |
 | ---------------------| ----------- |
-| `<date_or_time_expr>`| A valid date expression. Supports input of 
timestamptz/datetime/date/time types. If the type is date, it will be converted 
to the start time of the day (00:00:00). For specific formats, see [timestamptz 
conversion](../../../../sql-manual/basic-element/sql-data-types/conversion/timestamptz-conversion),
 [datetime 
conversion](../../../../../docs/sql-manual/basic-element/sql-data-types/conversion/datetime-conversion)
 and [time conversion](../../../../../docs/sql-manu [...]
+| `<date_or_time_expr>`| A valid date expression. Supports input of 
timestamptz/datetime/date/time types. If the type is date, it will be converted 
to the start time of the day (00:00:00). For specific formats, 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 [time conversion](../../../../sql-manual/basic-element [...]
 | `<time>`             | A valid time expression, representing the time value 
to be added to `<date_or_time_expr>`. If negative, it means subtraction. 
Supports input of time type. |
 
 ## Return Value
diff --git 
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/date-time-functions/quarters-add.md
 
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/date-time-functions/quarters-add.md
index 77fd42a35a1..3dd80b22640 100644
--- 
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/date-time-functions/quarters-add.md
+++ 
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/date-time-functions/quarters-add.md
@@ -104,8 +104,8 @@ SELECT QUARTERS_ADD('2025-10-10 11:22:33.123+07:00', 1);
 
 --- Calculation result exceeds date range
 SELECT QUARTERS_ADD('9999-10-31', 2) AS result;
-ERROR 1105 (HY000): errCode = 2, detailMessage = (10.16.10.3)[E-218]Operation 
month_add of 9999-10-31, 6 out of range
+ERROR 1105 (HY000): errCode = 2, detailMessage = (10.16.10.3)[E-218]Operation 
quarters_add of 9999-10-31, 6 out of range
 
 SELECT QUARTERS_ADD('0000-01-01',-2) AS result;
-ERROR 1105 (HY000): errCode = 2, detailMessage = (10.16.10.3)[E-218]Operation 
month_add of 0000-01-01, -6 out of range
+ERROR 1105 (HY000): errCode = 2, detailMessage = (10.16.10.3)[E-218]Operation 
quarters_add of 0000-01-01, -6 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/sec-to-time.md
 
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/date-time-functions/sec-to-time.md
index 352824ac201..e30588cdf76 100644
--- 
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/date-time-functions/sec-to-time.md
+++ 
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/date-time-functions/sec-to-time.md
@@ -27,7 +27,7 @@ SEC_TO_TIME(<seconds>)
 ## Return Value
 
 Returns a TIME type value converted from seconds.
-- If the input seconds exceed the valid range of TIME type (-838:59:59 to 
838:59:59, corresponding to seconds range -3023999 to 3023999), returns TIME 
max or min value
+- If the input seconds exceed the valid range of TIME type (-838:59:59 to 
838:59:59, corresponding to seconds range -3020399 to 3020399), returns TIME 
max or min value
 - If the input is NULL, returns NULL
 - if the input is an integer, the return format is HH:MM:SS; if the input is a 
floating-point number, the return format is HH:MM:SS.ssssss.
 
@@ -82,7 +82,7 @@ SELECT SEC_TO_TIME(NULL) AS result;
 | NULL   |
 +--------+
 
---- If the input seconds exceed the valid range of TIME type (-838:59:59 to 
838:59:59, corresponding to seconds range -3023999 to 3023999), returns TIME 
max or min value
+--- If the input seconds exceed the valid range of TIME type (-838:59:59 to 
838:59:59, corresponding to seconds range -3020399 to 3020399), returns TIME 
max or min value
  SELECT SEC_TO_TIME(30245000) AS result;
 +-----------+
 | result    |
diff --git 
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/date-time-functions/second-ceil.md
 
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/date-time-functions/second-ceil.md
index 484b36acb29..f2d88597143 100644
--- 
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/date-time-functions/second-ceil.md
+++ 
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/date-time-functions/second-ceil.md
@@ -31,7 +31,7 @@ SECOND_CEIL(<datetime>[, <period>][, <origin_datetime>])
 
 | Parameter | Description |
 | --------- | ----------- |
-| `<datetime>` | Required. The input datetime value. 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>` | Required. The input datetime value. 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>` | Optional. Indicates how many seconds make up each period. 
Supports positive integer type (INT). Default is 1 second. |
 | `<origin_datetime>` | Optional. The alignment starting point. Supports input 
of datetime type and strings that conform to datetime formats. If not 
specified, defaults to 0001-01-01T00:00:00. |
 
@@ -40,7 +40,7 @@ SECOND_CEIL(<datetime>[, <period>][, <origin_datetime>])
 Returns a value of type TIMESTAMPTZ, DATETIME or DATE. Returns the time value 
after rounding up to the nearest specified second period based on the input 
datetime. The precision of the return value matches the precision of the input 
datetime parameter.
 
 - If the input is TIMESTAMPTZ type, it will first be converted to local_time 
(for example: `2025-12-31 23:59:59+05:00` represents local_time `2026-01-01 
02:59:59` when the session variable is `+08:00`), and then perform SECOND_CEIL 
calculation.
-- If the input time values (`<date_or_time_expr>` and `<period>`) contain both 
TIMESTAMPTZ and DATETIME types, the output is DATETIME type.
+- If the input time values (`<datetime>` and `<period>`) contain both 
TIMESTAMPTZ and DATETIME types, the output is DATETIME type.
 - If `<period>` is a non-positive integer (≤0), returns an error.
 - If any parameter is NULL, returns NULL.
 - When period is not specified, defaults to a 1-second period.
diff --git 
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/date-time-functions/second-floor.md
 
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/date-time-functions/second-floor.md
index b3b7cd2b2fb..6d3cd0796a7 100644
--- 
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/date-time-functions/second-floor.md
+++ 
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/date-time-functions/second-floor.md
@@ -30,7 +30,7 @@ SECOND_FLOOR(<datetime>[, <period>][, <origin_datetime>])
 
 | Parameter | Description |
 | --------- | ----------- |
-| `<datetime>` | Required. The input datetime value. 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>` | Required. The input datetime value. 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>` | Optional. Indicates how many seconds make up each period. 
Supports positive integer type (INT). Default is 1 second. |
 | `<origin_datetime>` | Optional. The alignment starting point. Supports input 
of datetime type and strings that conform to datetime formats. If not 
specified, defaults to 0001-01-01T00:00:00. |
 
@@ -39,7 +39,7 @@ SECOND_FLOOR(<datetime>[, <period>][, <origin_datetime>])
 Returns a value of type TIMESTAMPTZ, DATETIME or DATE. Returns the time value 
after rounding down to the nearest specified second period based on the input 
datetime. The precision of the return value matches the precision of the input 
datetime parameter.
 
 - If the input is TIMESTAMPTZ type, it will first be converted to local_time 
(for example: `2025-12-31 23:59:59+05:00` represents local_time `2026-01-01 
02:59:59` when the session variable is `+08:00`), and then perform SECOND_FLOOR 
calculation.
-- If the input time values (`<date_or_time_expr>` and `<period>`) contain both 
TIMESTAMPTZ and DATETIME types, the output is DATETIME type.
+- If the input time values (`<datetime>` and `<period>`) contain both 
TIMESTAMPTZ and DATETIME types, the output is DATETIME type.
 - If `<period>` is a non-positive (≤0), returns error.
 - If any parameter is NULL, returns NULL.
 - When period is not specified, defaults to a 1-second period.
diff --git 
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/date-time-functions/sub-time.md
 
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/date-time-functions/sub-time.md
index 0ac02a58eee..8d135ca2ca8 100644
--- 
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/date-time-functions/sub-time.md
+++ 
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/date-time-functions/sub-time.md
@@ -20,7 +20,7 @@ SUB_TIME(`<date_or_time_expr>`, `<time>`)
 
 | Parameter             | Description |
 | ---------------------| ----------- |
-| `<date_or_time_expr>`| A valid date expression. Supports input of 
timestamptz/datetime/date/time types. If the type is date, it will be converted 
to the start time of the day (00:00:00). For specific formats, see [timestamptz 
conversion](../../../../sql-manual/basic-element/sql-data-types/conversion/timestamptz-conversion),
 [datetime 
conversion](../../../../../docs/sql-manual/basic-element/sql-data-types/conversion/datetime-conversion)
 and [time conversion](../../../../../docs/sql-manu [...]
+| `<date_or_time_expr>`| A valid date expression. Supports input of 
timestamptz/datetime/date/time types. If the type is date, it will be converted 
to the start time of the day (00:00:00). For specific formats, 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 [time conversion](../../../../sql-manual/basic-element [...]
 | `<time>`             | A valid time expression, representing the time value 
to be subtracted from `<date_or_time_expr>`. If negative, it means addition. 
Supports input of time type. |
 
 ## Return Value
diff --git 
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/date-time-functions/timestampadd.md
 
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/date-time-functions/timestampadd.md
index 576b19a0c4e..c9df5425b22 100644
--- 
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/date-time-functions/timestampadd.md
+++ 
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/date-time-functions/timestampadd.md
@@ -93,7 +93,7 @@ SELECT TIMESTAMPADD(YEAR,NULL, '2023-12-31 23:59:59') AS 
result;
 | NULL   |
 +--------+
 
--- Unit not supported, invalid
+-- Calculation result exceeds datetime range
 SELECT TIMESTAMPADD(YEAR,10000, '2023-12-31 23:59:59') AS result;
 ERROR 1105 (HY000): errCode = 2, detailMessage = (10.16.10.3)[E-218]Operation 
years_add of 2023-12-31 23:59:59, 10000 out of range
 ```
diff --git 
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/date-time-functions/timestampdiff.md
 
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/date-time-functions/timestampdiff.md
index 66bfcb30c8f..75d02a573ab 100644
--- 
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/date-time-functions/timestampdiff.md
+++ 
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/date-time-functions/timestampdiff.md
@@ -11,7 +11,7 @@
 Same functionality as the [date-diff function](./datediff)
 The TIMESTAMPDIFF function calculates the difference between two datetime 
values and returns the result in a specified time unit. This function supports 
multiple time units (such as seconds, minutes, hours, days, weeks, months, 
years).
 
-This function behaves consistently with the [date_diff 
function](https://dev.mysql.com/doc/refman/8.4/en/date-and-time-functions.html#function_date-diff)
 in MySQL.
+This function behaves consistently with the [timestampdiff 
function](https://dev.mysql.com/doc/refman/8.4/en/date-and-time-functions.html#function_timestampdiff)
 in MySQL.
 
 ## Syntax
 
diff --git 
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/date-time-functions/to-days.md
 
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/date-time-functions/to-days.md
index 0b2f4cd251d..0d633159c82 100644
--- 
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/date-time-functions/to-days.md
+++ 
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/date-time-functions/to-days.md
@@ -39,17 +39,17 @@ select to_days('0000-01-01');
 
 --input date type
 select to_days('2007-10-07');
-+---------------------------------------+
++-----------------------+
 | to_days('2007-10-07') |
-+---------------------------------------+
-|                                733321 |
-+---------------------------------------+
++-----------------------+
+|                733321 |
++-----------------------+
 
 --input datetime type
 select to_days('2007-10-07 10:03:09');
-+------------------------------------------------+
++--------------------------------+
 | to_days('2007-10-07 10:03:09') |
-+------------------------------------------------+
-|                                         733321 |
-+------------------------------------------------+
++--------------------------------+
+|                         733321 |
++--------------------------------+
 ```
diff --git 
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/date-time-functions/unix-timestamp.md
 
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/date-time-functions/unix-timestamp.md
index 14425bbbdbd..ed4f5e050e6 100644
--- 
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/date-time-functions/unix-timestamp.md
+++ 
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/date-time-functions/unix-timestamp.md
@@ -57,8 +57,8 @@ mysql> select unix_timestamp('1970-01-01 00:00:00');
 +---------------------------------------+
 | unix_timestamp('1970-01-01 00:00:00') |
 +---------------------------------------+
-|                            0 |
-+------------------------------+
+|                                     0 |
++---------------------------------------+
 
 -- Display timestamp of current time
 mysql> select unix_timestamp();
diff --git 
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/date-time-functions/utc-time.md
 
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/date-time-functions/utc-time.md
index 399f9dd5d84..6eb4caf0ae0 100644
--- 
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/date-time-functions/utc-time.md
+++ 
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/date-time-functions/utc-time.md
@@ -37,7 +37,7 @@ When the input is NULL or the precision is out of range, an 
error will be thrown
 SELECT UTC_TIME(), UTC_TIME() + 1, UTC_TIME(6), UTC_TIME(6) + 1;
 ```
 ```text
-------------+----------------+-----------------+-----------------+
++------------+----------------+-----------------+-----------------+
 | UTC_TIME() | UTC_TIME() + 1 | UTC_TIME(6)     | UTC_TIME(6) + 1 |
 +------------+----------------+-----------------+-----------------+
 | 06:39:01   |    23941000001 | 06:39:01.934119 |     23941934120 |
diff --git 
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/date-time-functions/week-floor.md
 
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/date-time-functions/week-floor.md
index 94f1a135fd1..d66bdec7c66 100644
--- 
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/date-time-functions/week-floor.md
+++ 
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/date-time-functions/week-floor.md
@@ -117,7 +117,7 @@ SELECT WEEK_FLOOR('2025-12-31 23:59:59+05:00', '2025-12-15 
00:00:00.123');
 
 -- Invalid period, returns error
 SELECT WEEK_FLOOR('2023-07-13', 0) AS result;
-RROR 1105 (HY000): errCode = 2, detailMessage = (10.16.10.3)[E-218]Operation 
week_floor of 2023-07-13 00:00:00, 0 out of range
+ERROR 1105 (HY000): errCode = 2, detailMessage = (10.16.10.3)[E-218]Operation 
week_floor of 2023-07-13 00:00:00, 0 out of range
 
 -- Parameter is NULL
 SELECT WEEK_FLOOR(NULL, 1) AS result;
diff --git 
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/date-time-functions/week.md
 
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/date-time-functions/week.md
index 38348b3c6b1..d45fe2a6a91 100644
--- 
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/date-time-functions/week.md
+++ 
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/date-time-functions/week.md
@@ -12,7 +12,6 @@ The WEEK function returns the week number for a specified 
date, with default Mod
 
 The effect of the mode parameter is shown in the following table:
 
-```sql
 |Mode |First day of week |Week number range |Definition of the first week      
               |
 
|:----|:-----------------|:-----------------|:------------------------------------------------|
 |0    |Sunday            |0-53             |The week containing the first 
Sunday of the year |
@@ -23,7 +22,7 @@ The effect of the mode parameter is shown in the following 
table:
 |5    |Monday            |0-53             |The week containing the first 
Monday of the year |
 |6    |Sunday            |1-53             |The first week with 4 or more days 
in this year  |
 |7    |Monday            |1-53             |The week containing the first 
Monday of the year |
-```
+
 
 This function is consistent with the [week 
function](https://dev.mysql.com/doc/refman/8.4/en/date-and-time-functions.html#function_week)
 in MySQL.
 
@@ -37,7 +36,7 @@ WEEK(`<date_or_time_expr>`, `<mode>`)
 
 | Parameter | Description |
 |-----------|-------------|
-| `<datetime_or_date>` | Input datetime value, supports date/datetime types. 
For datetime and date formats, please refer to [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>` | Input datetime value, supports date/datetime types. 
For datetime and date formats, please refer to [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)|
 | `mode` | Specified calculation method for the first week of the year, type 
INT, range 0-7 |
 
 ## Return Value
diff --git 
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/date-time-functions/weekday.md
 
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/date-time-functions/weekday.md
index 8366b51df7b..cd7f5a6c2e1 100644
--- 
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/date-time-functions/weekday.md
+++ 
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/date-time-functions/weekday.md
@@ -32,7 +32,7 @@ WEEKDAY(`<date_or_time_expr>`)
 
 | Parameter | Description |
 |-----------|-------------|
-| `<datetime_or_date>` | Input datetime value, supports date/datetime types. 
For datetime and date formats, please refer to [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>` | Input datetime value, supports date/datetime types. 
For datetime and date formats, please refer to [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)
 |
 
 ## Return Value
 Returns the index corresponding to the weekday of the date, type INT.
diff --git 
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/date-time-functions/weekofyear.md
 
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/date-time-functions/weekofyear.md
index 20f67452718..51a56de49f3 100644
--- 
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/date-time-functions/weekofyear.md
+++ 
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/date-time-functions/weekofyear.md
@@ -22,13 +22,13 @@ INT WEEKOFYEAR(`<date_or_time_expr>`)
 ## Parameters
 | Parameter | Description |
 |-----------|-------------|
-| `<datetime_or_date>` | Input datetime value, supports date/datetime types. 
For datetime and date formats, please refer to [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>` | Input datetime value, supports date/datetime types. 
For datetime and date formats, please refer to [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)
 |
 
 ## Return Value
 
 Returns INT type week number, range 1-53, representing which week of the year 
the date belongs to.
 
-- If the week containing January 1st has fewer than 4 days in the current year 
(e.g., if January 1st is a Wednesday, that week only has January 1-3 in the 
current year, totaling 3 days), then that week belongs to the previous year, 
and the 1st week of the current year starts from the next Sunday.
+- If the week containing January 1st has fewer than 4 days in the current year 
(e.g., if January 1st is a Wednesday, that week only has January 1-3 in the 
current year, totaling 3 days), then that week belongs to the previous year, 
and the 1st week of the current year starts from the next Monday.
 - When the week at the end of December has fewer than 4 days total, that week 
belongs to the first week of the next year
 - Input NULL returns NULL
 
diff --git 
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/date-time-functions/weeks-diff.md
 
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/date-time-functions/weeks-diff.md
index cf7e1fab313..a1878706cb0 100644
--- 
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/date-time-functions/weeks-diff.md
+++ 
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/date-time-functions/weeks-diff.md
@@ -104,9 +104,9 @@ SELECT WEEKS_DIFF('2024-01-01', '2023-12-25') AS cross_year;
 SELECT 
   WEEKS_DIFF(NULL, '2023-10-01') AS null_input1,
   WEEKS_DIFF('2023-10-01', NULL) AS null_input2;
-+------------+------------+
++-------------+-------------+
 | null_input1 | null_input2 |
-+------------+------------+
-| NULL       | NULL       |
-+------------+------------+
++-------------+-------------+
+| NULL        | NULL        |
++-------------+-------------+
 ```
\ No newline at end of file
diff --git 
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/date-time-functions/weeks-sub.md
 
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/date-time-functions/weeks-sub.md
index 5be4150c070..8e6c452cd33 100644
--- 
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/date-time-functions/weeks-sub.md
+++ 
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/date-time-functions/weeks-sub.md
@@ -86,9 +86,9 @@ SELECT WEEKS_SUB('2025-10-10 11:22:33.123+07:00', 1);
 
 -- The calculation result exceeds the lower bound of the datetime range.
 SELECT WEEKS_SUB('0000-01-01', 1);
-ERROR 1105 (HY000): errCode = 2, detailMessage = (10.16.10.3)[E-218]Operation 
weeks_add of 0000-01-01, -1 out of range
+ERROR 1105 (HY000): errCode = 2, detailMessage = (10.16.10.3)[E-218]Operation 
weeks_sub of 0000-01-01, -1 out of range
 
 -- The calculation result exceeds the upper bound of the datetime range.
 SELECT WEEKS_SUB('9999-12-31', -1);
-ERROR 1105 (HY000): errCode = 2, detailMessage = (10.16.10.3)[E-218]Operation 
weeks_add of 9999-12-31, 1 out of range
+ERROR 1105 (HY000): errCode = 2, detailMessage = (10.16.10.3)[E-218]Operation 
weeks_sub of 9999-12-31, 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/year-ceil.md
 
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/date-time-functions/year-ceil.md
index 97707fd1969..4a49e0a52d2 100644
--- 
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/date-time-functions/year-ceil.md
+++ 
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/date-time-functions/year-ceil.md
@@ -33,7 +33,7 @@ YEAR_CEIL(<date_or_time_expr>, <period>, <origin>)
 | Parameter | Description |
 |-----------|-------------|
 | `<date_or_time_expr>` | The datetime value to round up, supports 
date/datetime/timestamptz types. Date type will be converted to the start time 
00:00:00 of the corresponding date. 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/ [...]
-| `<period>` | Optional, represents how many seconds each period consists of, 
supports positive integer type (INT). Default is 1 second. |
+| `<period>` | Optional, represents how many years each period consists of, 
supports positive integer type (INT). Default is 1 year. |
 | `<origin_datetime>` | Starting point for the interval, supports 
date/datetime types; defaults to 0000-01-01 00:00:00. |
 
 ## Return Value
@@ -128,11 +128,11 @@ SELECT YEAR_CEIL('2023-07-13 22:22:56', 1, '2028-01-01 
08:30:00') AS result;
 -- TimeStampTz sample, SET time_zone = '+08:00'
 -- Convert to local_time (2026-01-01 02:59:59) and then perform YEAR_CEIL
 SELECT YEAR_CEIL('2025-12-31 23:59:59+05:00');
-+---------------------------------------+
-| YEAR_CEIL('2025-12-31 23:59:59+05:00')|
-+---------------------------------------+
-| 2027-01-01 00:00:00+08:00             |
-+---------------------------------------+
++----------------------------------------+
+| YEAR_CEIL('2025-12-31 23:59:59+05:00') |
++----------------------------------------+
+| 2027-01-01 00:00:00+08:00              |
++----------------------------------------+
 
 -- If parameters contain both TimeStampTz and Datetime types, output DateTime 
type
 SELECT YEAR_CEIL('2025-12-31 23:59:59+05:00', '2025-12-15 00:00:00.123');
diff --git 
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/date-time-functions/year-floor.md
 
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/date-time-functions/year-floor.md
index 145e3f9ecf7..4c2cf738f29 100644
--- 
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/date-time-functions/year-floor.md
+++ 
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/date-time-functions/year-floor.md
@@ -32,7 +32,7 @@ YEAR_FLOOR(<date_or_time_expr>, <period>, <origin>)
 | Parameter | Description |
 |-----------|-------------|
 | `<date_or_time_expr>` | The datetime value to round down, supports 
date/datetime/timestamptz types. Date type will be converted to the start time 
00:00:00 of the corresponding date. 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-elemen [...]
-| `<period>` | Optional, represents how many seconds each period consists of, 
supports positive integer type (INT). Default is 1 second. |
+| `<period>` | Optional, represents how many years each period consists of, 
supports positive integer type (INT). Default is 1 year. |
 | `<origin_datetime>` | Starting point for the interval, supports 
date/datetime types; defaults to 0000-01-01 00:00:00. |
 
 ## Return Value
@@ -157,11 +157,11 @@ SELECT YEAR_FLOOR('2023-07-13 10:00:00', 1, '2020-01-01 
08:30:00') AS result;
 -- TimeStampTz sample, SET time_zone = '+08:00'
 -- Convert to local_time (2026-01-01 02:59:59) and then perform YEAR_FLOOR
 SELECT YEAR_FLOOR('2025-12-31 23:59:59+05:00');
-+----------------------------------------+
-| YEAR_FLOOR('2025-12-31 23:59:59+05:00')|
-+----------------------------------------+
-| 2026-01-01 00:00:00+08:00              |
-+----------------------------------------+
++-----------------------------------------+
+| YEAR_FLOOR('2025-12-31 23:59:59+05:00') |
++-----------------------------------------+
+| 2026-01-01 00:00:00+08:00               |
++-----------------------------------------+
 
 -- If parameters contain both TimeStampTz and Datetime types, output DateTime 
type
 SELECT YEAR_FLOOR('2025-12-31 23:59:59+05:00', '2025-12-15 00:00:00.123');
diff --git 
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/date-time-functions/years-sub.md
 
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/date-time-functions/years-sub.md
index 66a19eb5e2a..e79e5e7a874 100644
--- 
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/date-time-functions/years-sub.md
+++ 
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/date-time-functions/years-sub.md
@@ -90,9 +90,9 @@ SELECT YEARS_SUB('2025-10-10 11:22:33.123+07:00', 1);
 
 -- Calculation result exceeds datetime range (upper limit)
 SELECT YEARS_SUB('9999-12-31', -1);
-ERROR 1105 (HY000): errCode = 2, detailMessage = (10.16.10.3)[E-218]Operation 
year_add of 9999-12-31, 1 out of range
+ERROR 1105 (HY000): errCode = 2, detailMessage = (10.16.10.3)[E-218]Operation 
years_sub of 9999-12-31, 1 out of range
 
 -- Calculation result exceeds datetime range (lower limit)
 SELECT YEARS_SUB('0000-01-01', 1);
-ERROR 1105 (HY000): errCode = 2, detailMessage = (10.16.10.3)[E-218]Operation 
year_add of 0000-01-01, -1 out of range
+ERROR 1105 (HY000): errCode = 2, detailMessage = (10.16.10.3)[E-218]Operation 
years_sub of 0000-01-01, -1 out of range
 ```
diff --git 
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/encrypt-digest-functions/aes-decrypt.md
 
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/encrypt-digest-functions/aes-decrypt.md
index 43eeb4b6104..04a3179aad0 100644
--- 
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/encrypt-digest-functions/aes-decrypt.md
+++ 
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/encrypt-digest-functions/aes-decrypt.md
@@ -2,7 +2,7 @@
 {
     "title": "AES_DECRYPT",
     "language": "en",
-    "description": "AES decryption function. This function behaves the same as 
the AESDECRYPT function in MySQL. The default algorithm is AES128ECB,"
+    "description": "AES decryption function. This function behaves the same as 
the AES_DECRYPT function in MySQL. The default algorithm is AES_128_ECB,"
 }
 ---
 
diff --git 
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/encrypt-digest-functions/aes-encrypt.md
 
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/encrypt-digest-functions/aes-encrypt.md
index 3dfd3df2d4f..3c54beefff8 100644
--- 
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/encrypt-digest-functions/aes-encrypt.md
+++ 
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/encrypt-digest-functions/aes-encrypt.md
@@ -2,7 +2,7 @@
 {
     "title": "AES_ENCRYPT",
     "language": "en",
-    "description": "AES encryption function. This function behaves the same as 
the AESENCRYPT function in MySQL. The default algorithm is AES128ECB,"
+    "description": "AES encryption function. This function behaves the same as 
the AES_ENCRYPT function in MySQL. The default algorithm is AES_128_ECB,"
 }
 ---
 
@@ -12,7 +12,7 @@ AES encryption function. This function behaves the same as 
the `AES_ENCRYPT` fun
 
 The AES_ENCRYPT function does not use the passed key directly, but further 
processes it. The specific steps are as follows:
 1. Determine the number of bytes of the key according to the encryption 
algorithm used. For example, if the AES_128_ECB algorithm is used, the number 
of bytes of the key is `128 / 8 = 16` (if the AES_256_ECB algorithm is used, 
the number of bytes of the key is `256 / 8 = 32`);
-2. Then, for the key input by the user, the `i`th bit and the `16*k+i`th bit 
are XORed. If the key input by the user is less than 16 bits, 0 is added at the 
end.
+2. Then, for the key input by the user, the `i`th byte and the `16*k+i`th byte 
are XORed. If the key input by the user is less than 16 bytes, 0 is added at 
the end.
 3. Finally, use the newly generated key to encrypt;
 
 ## Syntax
diff --git 
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/encrypt-digest-functions/murmur-hash3-32.md
 
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/encrypt-digest-functions/murmur-hash3-32.md
index 2cfcf4c3164..6bc8f51ee9b 100644
--- 
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/encrypt-digest-functions/murmur-hash3-32.md
+++ 
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/encrypt-digest-functions/murmur-hash3-32.md
@@ -10,7 +10,7 @@
 
 Calculate 32-bit murmur3 hash value
 
--Note: When calculating hash values, it is recommended to use `xxhash_32` 
instead of `murmur_hash3_32`。
+- Note: When calculating hash values, it is recommended to use `xxhash_32` 
instead of `murmur_hash3_32`.
 
 ## Syntax
 


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

(doris-website) branch master updated: [fix] correct date-time and encrypt-digest function doc issues (#3710)

Reply via email to