Previous Topic Next topic Print topic


XDATE

ANSI DB2 SQL/DS XDB
      X

The XDATE function takes 3 integers and converts them into a date. The format appears below:

XDATE(m, d, y)

The m parameter is an expression that evaluates to an integer representing a month of the year (1-12). The d parameter is an expression that evaluates to an integer representing a day of the month (1-31). The y parameter is an expression that evaluates to an integer representing a year. For example, the following command creates an employee birthday calendar for the current year.

SELECT "Birthday for", fname, lname,"is", 
  XDATE(XMONTH(birth), XDAY(birth), XYEAR(TODAY))
FROM bdaylist
Previous Topic Next topic Print topic