blob: d9490e20a3b6dbb95600cac6ffb2ebb36ab28150 (
plain) (
blame)
1
2
3
4
5
6
|
dayofmonth(date) - Returns the date of the month of date
Synonyms: day
date is a string in the format of 'yyyy-MM-dd HH:mm:ss' or 'yyyy-MM-dd'.
Example:
> SELECT dayofmonth('2009-30-07', 1) FROM src LIMIT 1;
30
|