morrySnow commented on code in PR #1805:
URL: https://github.com/apache/doris-website/pull/1805#discussion_r1917837810
##########
docs/sql-manual/sql-functions/scalar-functions/date-time-functions/months-add.md:
##########
@@ -24,27 +24,40 @@ specific language governing permissions and limitations
under the License.
-->
-## months_add
-### description
-#### Syntax
+## Description
+The MONTHS_ADD function is used to add or subtract a specified number of
months to a given date and returns the resulting date.
-`DATETIME MONTHS_ADD(DATETIME date, INT months)`
+## Syntax
-Add the specified month from the date
+`DATETIME MONTHS_ADD(DATETIME/DATE <datetime/date>, INT <nums>)`
Review Comment:
```suggestion
`MONTHS_ADD(<datetime/date>, <nums>)`
```
##########
docs/sql-manual/sql-functions/scalar-functions/date-time-functions/months-add.md:
##########
@@ -24,27 +24,40 @@ specific language governing permissions and limitations
under the License.
-->
-## months_add
-### description
-#### Syntax
+## Description
+The MONTHS_ADD function is used to add or subtract a specified number of
months to a given date and returns the resulting date.
-`DATETIME MONTHS_ADD(DATETIME date, INT months)`
+## Syntax
-Add the specified month from the date
+`DATETIME MONTHS_ADD(DATETIME/DATE <datetime/date>, INT <nums>)`
-The parameter date can be DATETIME or DATE, and the return type is consistent
with that of the parameter date.
+## Parameters
-### example
+| Parameter | Description
|
+|-------------------|------------------------------------------------------------|
+| `<datetime/date>` | The date value to which months will be added or
subtracted |
+| `<nums>` | The number of months to add or subtract
|
+## Return Value
+The return value is of the same type as the input <datetime/date>.
+Special cases:
+- If the <datetime/date> input is 0000-00-00 or 0000-00-00 00:00:00, the
function returns NULL.
+- If the <datetime/date> input is NULL, the function returns NULL.
+- If the input is MONTHS_ADD("9999-12-31", 1), the function will return NULL.
+
+## Example
+
+``` sql
+select months_add("2020-01-31 02:02:02", 1),months_add("2020-01-31",
1),months_add("2020-01-31", -1);
```
-mysql> select months_add("2020-01-31 02:02:02", 1);
-+--------------------------------------+
-| months_add('2020-01-31 02:02:02', 1) |
-+--------------------------------------+
-| 2020-02-29 02:02:02 |
-+--------------------------------------+
+```text
++-------------------------------------------------------------+---------------------------------------------+----------------------------------------------+
+| months_add(cast('2020-01-31 02:02:02' as DATETIMEV2(0)), 1) |
months_add(cast('2020-01-31' as DATEV2), 1) | months_add(cast('2020-01-31' as
DATEV2), -1) |
++-------------------------------------------------------------+---------------------------------------------+----------------------------------------------+
+| 2020-02-29 02:02:02 | 2020-02-29
| 2019-12-31 |
++-------------------------------------------------------------+---------------------------------------------+----------------------------------------------+
```
-### keywords
+## keywords
Review Comment:
移除keywords章节
##########
docs/sql-manual/sql-functions/scalar-functions/date-time-functions/months-sub.md:
##########
@@ -24,27 +24,40 @@ specific language governing permissions and limitations
under the License.
-->
-## months_sub
-### description
-#### Syntax
+## Description
+The MONTHS_SUB function is used to add or subtract a specified number of
months to a given date and returns the resulting date.
-`DATETIME MONTHS_SUB(DATETIME date, INT months)`
+## Syntax
-Subtracts a specified number of months from a datetime or date
+`DATETIME MONTHS_SUB(DATETIME/DATE <datetime/date>, INT <nums>)`
-The parameter date can be DATETIME or DATE, and the return type is consistent
with that of the parameter date.
+## Parameters
-### example
+| Parameter | Description
|
+|-------------------|------------------------------------------------------------|
+| `<datetime/date>` | The date value to which months will be added or
subtracted |
+| `<nums>` | The number of months to add or subtract
|
+## Return Value
+The return value is of the same type as the input <datetime/date>.
+Special cases:
+- If the <datetime/date> input is 0000-00-00 or 0000-00-00 00:00:00, the
function returns NULL.
+- If the <datetime/date> input is NULL, the function returns NULL.
+- If the input is MONTHS_SUB("9999-12-31", -1), the function will return NULL.
+
+## Example
+
+``` sql
+select months_sub("2020-01-31 02:02:02", 1),months_sub("2020-01-31",
1),months_sub("2020-01-31", -1);
```
-mysql> select months_sub("2020-02-02 02:02:02", 1);
-+--------------------------------------+
-| months_sub('2020-02-02 02:02:02', 1) |
-+--------------------------------------+
-| 2020-01-02 02:02:02 |
-+--------------------------------------+
+```text
++-------------------------------------------------------------+---------------------------------------------+----------------------------------------------+
+| months_sub(cast('2020-01-31 02:02:02' as DATETIMEV2(0)), 1) |
months_sub(cast('2020-01-31' as DATEV2), 1) | months_sub(cast('2020-01-31' as
DATEV2), -1) |
++-------------------------------------------------------------+---------------------------------------------+----------------------------------------------+
+| 2019-12-31 02:02:02 | 2019-12-31
| 2020-02-29 |
++-------------------------------------------------------------+---------------------------------------------+----------------------------------------------+
```
-### keywords
+## keywords
Review Comment:
移除 keywords 章节
##########
docs/sql-manual/sql-functions/scalar-functions/date-time-functions/months-sub.md:
##########
@@ -24,27 +24,40 @@ specific language governing permissions and limitations
under the License.
-->
-## months_sub
-### description
-#### Syntax
+## Description
+The MONTHS_SUB function is used to add or subtract a specified number of
months to a given date and returns the resulting date.
-`DATETIME MONTHS_SUB(DATETIME date, INT months)`
+## Syntax
-Subtracts a specified number of months from a datetime or date
+`DATETIME MONTHS_SUB(DATETIME/DATE <datetime/date>, INT <nums>)`
Review Comment:
```suggestion
`MONTHS_SUB(<datetime/date>, <nums>)`
```
--
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]
