boluor opened a new pull request, #3854:
URL: https://github.com/apache/doris-website/pull/3854
## Problem
The EN example for `SECOND()` runs `select second('2018-12-31 23:59:59')`
but the expected-output block is wrong in two ways:
- the column header echoes `cast('2018-12-30' ...)`, a datetime that does
not match the query input; and
- the value is shown as `0`, whereas the second component of `23:59:59` is
`59`.
The ZH version of this page already shows the correct header and value `59`,
so only the EN page changes.
## Cluster verification (Doris 3.1.4-rc02)
```
mysql> select second('2018-12-31 23:59:59');
+------------------------------------------------------+
| second(cast('2018-12-31 23:59:59' as DATETIMEV2(0))) |
+------------------------------------------------------+
| 59 |
+------------------------------------------------------+
```
🤖 Generated with [Claude Code](https://claude.com/claude-code)
--
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]
