You are viewing an older version of this section. View current production version.
Join the MemSQL Community Today
Get expert advice, develop skills, and connect with others.

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

memsql> select day('2009-02-13');
+-------------------+
| day('2009-02-13') |
+-------------------+
|                13 |
+-------------------+