day() is a helper routine that simplifies the creation of an oft-used SQL statement to obtain just the day of a specified date/time field as a 2 digit number (DD). If the value of the day is less than 10, it is zero padded. This allows for correct sorting.
The date/time fieldname to be processed
In the following example, we analyze the most often occurring day of the month for a birth date