MariaDB: MAKEDATE Function
This MariaDB tutorial explains how to use the MariaDB MAKEDATE function with syntax and examples.
Description
The MariaDB MAKEDATE function returns the date for a certain year and day-of-year value.
Syntax
The syntax for the MariaDB MAKEDATE function is:
MAKEDATE( year, day-of-year )
Parameters or Arguments
- year
- A 4-digit year used to create the date.
- day-of-year
- A day of the year (greater than 0) used to create the date.
Note
- If day-of-year is less than 1, the MAKEDATE function will return NULL.
Applies To
The MAKEDATE function can be used in the following versions of MariaDB:
- MariaDB 10
Example
Let's look at some MariaDB MAKEDATE function examples and explore how to use the MAKEDATE function in MariaDB.
For example:
SELECT MAKEDATE(2014,1); Result: '2014-01-01' SELECT MAKEDATE(2014,15); Result: '2014-01-15' SELECT MAKEDATE(2014,176); Result: '2014-06-25' SELECT MAKEDATE(2014,365); Result: '2014-12-31' SELECT MAKEDATE(2014,366); -- Not leap year in 2014 Result: '2015-01-01' SELECT MAKEDATE(2016,366); -- Leap year in 2016 Result: '2016-12-31'
Advertisements