totn MariaDB Functions

MariaDB: FROM_DAYS Function

This MariaDB tutorial explains how to use the MariaDB FROM_DAYS function with syntax and examples.

Description

The MariaDB FROM_DAYS function converts a numeric day into a date value.

Syntax

The syntax for the FROM_DAYS function in MariaDB is:

FROM_DAYS( date )

Parameters or Arguments

date
The date to convert to numeric days.

Note

  • The FROM_DAYS function is to be used only with dates within the Gregorian calendar.
  • See also the TO_DAYS function which is the reverse of the FROM_DAYS function.

Applies To

The FROM_DAYS function can be used in the following versions of MariaDB:

  • MariaDB 10

Example

Let's look at some MariaDB FROM_DAYS function examples and explore how to use the FROM_DAYS function in MariaDB.

For example:

SELECT FROM_DAYS(735918);
Result: '2014-11-16'

SELECT FROM_DAYS(735919);
Result: '2014-11-17'

SELECT FROM_DAYS(735920);
Result: '2014-11-18'
Share on: