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