Returns the date as year, month, and day.
| Category: | Date and Time |
| Returned data type: | DATE |
specifies the year.
specifies the month.
specifies the day.
|
Statements
|
Results
|
|---|---|
select makedate(2013, 10, 30); |
30OCT2013 |
select makedate(y, m, d) from adate; |
30OCT2013 |