Watch the 7.3 Webinar On-Demand
This new release brings updates to Universal Storage, query
optimization, and usability that you won’t want to miss.
DAY
Extracts the day of the month from the given datetime.
Syntax
DAY ( dateobj )
Arguments
- dateobj: a valid date, datetime, or parsable date string.
Return Type
Integer
Examples
select day('2009-02-13');
+-------------------+
| day('2009-02-13') |
+-------------------+
| 13 |
+-------------------+
