Home » MySQL » MySQL date/time Functions

MySQL FROM_DAYS() Function

MySQL | FROM_DAYS() Function: Learn about the FROM_DAYS() function, how it works, its usages, syntax, and examples.
Submitted by Apurva Mathur, on October 05, 2022

FROM_DAYS() Function

The FROM_DAYS() function converts the numeric date value to the date. The numeric date value which we provide is divided by 365.

FROM_DAYS() Syntax

SELECT FROM_DAYS(numeric_value);

FROM_DAYS() Parameter(s)

• numeric_value: It accepts a value which you want to convert to date.

FROM_DAYS() Return Value

It returns the date after converting the numeric value.

MySQL FROM_DAYS() Function Example 1

SELECT FROM_DAYS('23345');

MySQL FROM_DAYS() Function Example 2

SELECT FROM_DAYS('456887');

MySQL FROM_DAYS() Function Example 3

SELECT FROM_DAYS('47346');

---