day
Returns day of the month from a timestamp.
Example
day(date("2001-12-24 23:55:12.000"))This example returns 24.
Syntax
day(date expr d)- d : expression evaluating to
date
Returns
int
Notes
Function day evaluates a date expression and returns the day of the month.