Skip to content
DBCode

FROM_DAYS

FROM_DAYS(N)

Section titled “FROM_DAYS(N)”
  • n: This parameter denotes the number of days passed since year zero in the Gregorian calendar. It is an integer value which is used to calculate and return a date.

Example

Section titled “Example”
SELECT FROM_DAYS(736881);

Output

Section titled “Output”
'2019-12-31'

Explanation

Section titled “Explanation”

The FROM_DAYS function in MySQL converts the given day number to a date. In this example, day number 736881 is converted to the corresponding date ‘2019-12-31’.