MAKEDATE(a,b) is a date function that supplies a date value from a year and day value.
The expressions a and b (expression) in MAKEDATE must supply numeric values. The following restrictions also apply:
a>=0 (a represents a year value)
b>0 (b represents a day value)
Decimal places in a and b are truncated if necessary.
a, b |
Result of the MAKEDATE(a,b) function |
---|---|
a or b is a NULL value |
NULL value |
a or b is a special NULL value |
Error Messages |
Example
MAKEDATE(2008,49) in the INTERNAL date format outputs 2008-02-18