day_in_month(date)

Returns an integer representing the day of the month for a specific date.

q = foreach q generate day_in_month('OrderDate') as "Day in Month";