MDY()
The MDY() operator creates a
DATE from month, day and year units.
Syntax
MDY ( expr1, expr2, expr3 ) - expr1 is an integer representing the month (from 1 to 12).
- expr2 is an integer representing the day (from 1 to 28, 29, 30 or 31 depending on the month).
- expr3 is an integer representing the year (four digits).
Usage
The MDY() operator builds a date value with 3 integers representing the month,
day and year. The result is a DATE
value.
This function is sensitive to the C1 modifier of the DBDATE environment variable, defining a Ming Guo date
format.
Example
MAIN
DISPLAY MDY ( 12, 3+2, 1998 )
END MAIN