Mysql FROM DAYS
From w3cyberlearnings
Contents |
MySQL FROM_DAYS Function
This function returns a date value from the number of days in put.
Syntax FROM_DAYS
N: Number of days
FROM_DAYS(N);
Example 1
mysql> SELECT FROM_DAYS(740554); +-------------------+ | FROM_DAYS(740554) | +-------------------+ | 2027-07-27 | +-------------------+ 1 row in set (0.00 sec)
Example 2
mysql> SELECT FROM_DAYS(735001); +-------------------+ | FROM_DAYS(735001) | +-------------------+ | 2012-05-13 | +-------------------+ 1 row in set (0.00 sec)