MDY()

The MDY() operator creates a DATE from month, day and year units.

Syntax

MDY ( expr1, expr2, expr3 )
  1. expr1 is an integer representing the month (from 1 to 12).
  2. expr2 is an integer representing the day (from 1 to 28, 29, 30 or 31 depending on the month).
  3. 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