mdy()

The mdy operator returns a DATE value derived from three integers that represent the month, day of the month, and year of a calendar date.
  DateTimeLib.mdy(
    month INT in,
    day INT in,
    year INT in)
  returns (result DATE)
result
A DATE value.
month
An integer in the range 1 through 12, representing the month.
day
An integer representing the day of the month in the range 1 through 28, 29, 30, or 31, depending on the month.
year
A four-digit integer representing the year.
An error results if you specify values outside the range of days and months in the calendar or if the number of operands is not three. You must enclose the three integer expression operands between parentheses, separated by commas, just as you would if MDY( ) were a function. The third expression cannot be the abbreviation for the year. For example, 99 specifies a year in the first century, approximately 1,900 years ago.

Related concepts
Syntax diagram for EGL functions

Related reference
DATE
EGL library DateTimeLib

Feedback
(C) Copyright IBM Corporation 2000, 2005. All Rights Reserved.