Make_date

sql

FUNCTION Make_date(IN day INT, IN month INT, IN year INT) RETURNS DATE;

Parameters

day day in month (1 to 31)
month month (1 to 12)
year year (0 and higher)

Description

The Make_date function creates the dat from the 3 components: day, month and year. BC dates are not allowed.

Function value

This function returns the created date. If the dat cannot be created (e.g. 31.2.1994), the function will return NULL.

See