Mysql MAKEDATE
From w3cyberlearnings
Contents |
MySQL MAKEDATE Function
This function makes date from year and days input.
Syntax MAKEDATE
- year: year input
- days: total days
MAKEDATE(year,days);
Example 1
mysql> SELECT MAKEDATE(2012,30); +-------------------+ | MAKEDATE(2012,30) | +-------------------+ | 2012-01-30 | +-------------------+ 1 row in set (0.00 sec)
Example 2
mysql> SELECT MAKEDATE(2012,70); +-------------------+ | MAKEDATE(2012,70) | +-------------------+ | 2012-03-10 | +-------------------+ 1 row in set (0.00 sec)
