MAKETIME
Syntax
MAKETIME(hour,minute,second)
Description
Returns a time value calculated from the hour
, minute
, and second
arguments.
If minute
or second
are out of the range 0 to 60, NULL is returned. The hour
can be in the range -838 to 838, outside of which the value is truncated with a warning.
Examples
SELECT MAKETIME(13,57,33); +--------------------+ | MAKETIME(13,57,33) | +--------------------+ | 13:57:33 | +--------------------+ SELECT MAKETIME(-13,57,33); +---------------------+ | MAKETIME(-13,57,33) | +---------------------+ | -13:57:33 | +---------------------+ SELECT MAKETIME(13,67,33); +--------------------+ | MAKETIME(13,67,33) | +--------------------+ | NULL | +--------------------+ SELECT MAKETIME(-1000,57,33); +-----------------------+ | MAKETIME(-1000,57,33) | +-----------------------+ | -838:59:59 | +-----------------------+ 1 row in set, 1 warning (0.00 sec) SHOW WARNINGS; +---------+------+-----------------------------------------------+ | Level | Code | Message | +---------+------+-----------------------------------------------+ | Warning | 1292 | Truncated incorrect time value: '-1000:57:33' | +---------+------+-----------------------------------------------+
Content reproduced on this site is the property of its respective owners,
and this content is not reviewed in advance by MariaDB. The views, information and opinions
expressed by this content do not necessarily represent those of MariaDB or any other party.