morrySnow commented on code in PR #1820:
URL: https://github.com/apache/doris-website/pull/1820#discussion_r1918308720
##########
docs/sql-manual/sql-functions/scalar-functions/date-time-functions/convert-tz.md:
##########
@@ -24,32 +24,47 @@ specific language governing permissions and limitations
under the License.
-->
-## convert_tz
-### Description
-#### Syntax
+## Description
-`DATETIME CONVERT_TZ(DATETIME dt, VARCHAR from_tz, VARCHAR to_tz)`
+Converts a datetime value from the time zone specified by from_tz to the time
zone specified by to_tz, and returns the resulting value. Special cases:
+- If the parameters are invalid, the function returns NULL.
-Convert datetime value. Go from the given input time zone to the specified
time zone and return the result value. If the argument is invalid, the function
returns null.
+## Syntax
-### Example
+```sql
+DATETIME CONVERT_TZ(DATETIME dt, VARCHAR from_tz, VARCHAR to_tz)
+```
+
+## Parameters
+
+| Parameter | Description |
+| -- | -- |
+| dt | The datetime value to be converted |
+| from_tz | The original time zone of dt |
+| to_tz | The target time zone to convert to |
+## Examples
Review Comment:
缺少返回值章节
##########
docs/sql-manual/sql-functions/scalar-functions/date-time-functions/date-add.md:
##########
@@ -24,27 +24,44 @@ specific language governing permissions and limitations
under the License.
-->
-## days_add
-### description
-#### Syntax
+## Description
-`DATETIME DAYS_ADD(DATETIME date, INT days)`
+Add a specified time interval to the date.
-From date time or date plus specified days
+## Alias
-The parameter date can be DATETIME or DATE, and the return type is consistent
with that of the parameter date.
+- date_add
+- days_add
+- adddate
-### example
+## Syntax
+```sql
+DATETIME DATE_ADD(DATETIME date, INTERVAL expr type)
```
-mysql> select days_add(to_date("2020-02-02 02:02:02"), 1);
-+---------------------------------------------+
-| days_add(to_date('2020-02-02 02:02:02'), 1) |
-+---------------------------------------------+
-| 2020-02-03 |
-+---------------------------------------------+
-```
-### keywords
+## Parameters
+
+| Parameter | Description |
+| -- | -- |
+| date | A valid date value |
+| expr | The time interval you want to add |
+| type | Enumerated values: YEAR, QUARTER, MONTH, DAY, HOUR, MINUTE, SECOND |
Review Comment:
type -> time_unit
##########
docs/sql-manual/sql-functions/scalar-functions/date-time-functions/convert-tz.md:
##########
@@ -24,32 +24,47 @@ specific language governing permissions and limitations
under the License.
-->
-## convert_tz
-### Description
-#### Syntax
+## Description
-`DATETIME CONVERT_TZ(DATETIME dt, VARCHAR from_tz, VARCHAR to_tz)`
+Converts a datetime value from the time zone specified by from_tz to the time
zone specified by to_tz, and returns the resulting value. Special cases:
+- If the parameters are invalid, the function returns NULL.
-Convert datetime value. Go from the given input time zone to the specified
time zone and return the result value. If the argument is invalid, the function
returns null.
+## Syntax
-### Example
+```sql
+DATETIME CONVERT_TZ(DATETIME dt, VARCHAR from_tz, VARCHAR to_tz)
Review Comment:
```suggestion
CONVERT_TZ(dt, from_tz, to_tz)
```
##########
docs/sql-manual/sql-functions/scalar-functions/date-time-functions/date-format.md:
##########
@@ -24,20 +24,27 @@ specific language governing permissions and limitations
under the License.
-->
-## date_format
-### Description
-#### Syntax
+## Description
-`VARCHAR DATE_FORMAT (DATETIME DATE, VARCHAR Format)`
+Convert the date type to a bit string according to the format type.
+## Syntax
-Convert the date type to a string according to the format type.
-Convert the date type to a string according to the format type. Currently, it
supports a maximum of 128 bytes for the string. If the return value length
exceeds 128 bytes, then it returns NULL.
+```sql
+VARCHAR DATE_FORMAT(DATETIME date, VARCHAR format)
+```
+
+## Parameters
+
+| Parameter | Description |
+| -- | -- |
+| date | A valid date value |
+| format | Specifies the output format for the date/time |
-The date parameter is the valid date. Format specifies the date/time output
format.
The formats available are:
+```text
Review Comment:
使用另外一个表格可以更清楚的展示
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
