跳到主要内容

toStartOfSecond

Rounds down a date with time to the start of the second.

Syntax​

toStartOfSecond(expr)

Arguments​

ArgumentsDescription
exprdatetime

Return Type​

Datetime object, returns date in “YYYY-MM-DD hh:mm:ss” format.

Examples​

SELECT toStartOfSecond(now());;
+------------------------+
| toStartOfSecond(now()) |
+------------------------+
| 2022-04-13 13:53:47    |
+------------------------+