MAKEDATE()
returns a date by taking a value of a year and a number of days. The number of
days must be greater than 0 other wise a NULL will be returned.
mysql> SELECT MAKEDATE(2016, 234); +---------------------+ | MAKEDATE(2016, 234) | +---------------------+ | 2016-08-21 | +---------------------+ 1 row in set (0.00 sec) mysql> SELECT MAKEDATE(2016, -10); +---------------------+ | MAKEDATE(2016, -10) | +---------------------+ | NULL | +---------------------+ 1 row in set (0.00 sec) mysql> SELECT MAKEDATE(2016, 0); +-------------------+ | MAKEDATE(2016, 0) | +-------------------+ | NULL | +-------------------+ 1 row in set (0.00 sec)
Previous Next Home
No comments:
Post a Comment