FROM_DAYS(N)

Diberikan nomor hari N, mengembalikan nilai DATE. Mengembalikan NULL jika N adalah NULL.

Syntax

MYSQL Copy

SELECT FROM_DAYS(730669);
'2000-07-03'

Contoh

Example

Use FROM_DAYS() with caution on old dates. It is not intended for use with values that precede the advent of the Gregorian calendar (1582). See Section 13.2.7, “What Calendar Is Used By MySQL?”.

MYSQL Copy

SELECT FROM_DAYS(730669);
'2000-07-03'