MAKEDATE Function

Returns the date as year, month, and day.

Category: Date and Time
Returned data type: DATE

Syntax

MAKEDATE(y, m, d)

Arguments

y

specifies the year.

m

specifies the month.

d

specifies the day.

Example

The following statements illustrates the MAKEDATE function:
Statements
Results
select makedate(2013, 10, 30);
30OCT2013
select makedate(y, m, d) from adate;
30OCT2013
Last updated: February 23, 2017