Jump to: navigation, search

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)

Related Links



Navigation
Web
SQL
MISC
References