MDY Function

The MDY function takes as its arguments three integer expressions that represent the month, day, and year, and returns a type DATE value.

  • The first argument represents the number of the month (1 to 12).
  • The second argument represents the number of the day of the month (1 to 28, 29, 30, or 31, as appropriate for the month).
  • The third argument represents the 4-digit year. You cannot use a 2-digit abbreviation.

Example of the MDY function in an UPDATE statement

The following example updates a row in the orders table whose purchase-order number is 8052 by changing its paid_date column value to the first day of the current month: 
UPDATE orders SET paid_date = MDY(MONTH(TODAY), 1, YEAR(TODAY))
   WHERE po_num = '8052';
Here the first and last arguments to the MDY function are time expressions that return integers corresponding to the current month and year. The second argument specifies the day of the month as a literal integer. Reversing the order of the first two arguments in this example would change the paid_date value to some day before January 13 of the current year, unless the same application also included error-checking code that identified that date as too early to be valid.