IDAY

(IDAY(arg))

Where arg is a value that has either a DATE or DATETIME data type, IDAY returns the integer day of the month for a particular date.

In the following example, the value of viday is 12.

SET VAR viday = (IDAY('06/12/93'))