FROM_DAYS
You are viewing an old version of this article. View
the current version here.
Syntax
FROM_DAYS(N)
Description
Given a day number N, returns a DATE value. The day count is based on the number of days from the start of the standard calendar (0000-00-00).
The function is not designed for use with dates before the advent of the Gregorian calendar in October 1582. Results will not be reliable since it doesn't account for the lost days when the calendar changed from the Julian calendar.
This is the converse of the TO_DAYS() function.
Examples
SELECT FROM_DAYS(730669); +-------------------+ | FROM_DAYS(730669) | +-------------------+ | 2000-07-03 | +-------------------+
Comments
Comments loading...
Content reproduced on this site is the property of its respective owners,
and this content is not reviewed in advance by MariaDB. The views, information and opinions
expressed by this content do not necessarily represent those of MariaDB or any other party.
