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