blob: 9e931f649914b00e31b13d109bd0592f27f277ee (
plain) (
blame)
1
2
3
4
5
6
7
8
9
|
dayofmonth(param) - Returns the day of the month of date/timestamp, or day component of interval
Synonyms: day
param can be one of:
1. A string in the format of 'yyyy-MM-dd HH:mm:ss' or 'yyyy-MM-dd'.
2. A date value
3. A timestamp value
4. A day-time interval valueExample:
> SELECT dayofmonth('2009-07-30') FROM src LIMIT 1;
30
|