• ⌂ Date & Time
• Functions
  • ADDDATE()
  • ADDTIME()
  • CURDATE()
  • CURRENT_DATE()
  • CURRENT_TIME()
  • CURRENT_TIMESTAMP()
  • CURTIME()
  • DATE()
  • DATEDIFF()
  • DATE_ADD()
  • DATE_FORMAT()
  • DATE_SUB()
  • DAY()
  • DAYOFMONTH()
  • DAYOFYEAR()
  • HOUR()
  • MICROSECOND()
  • MINUTE()
  • MONTH()
  • NOW()
  • SECOND()
  • TIME()
  • TIMEDIFF()
  • UNIX_TIMESTAMP()
  • WEEK()
  • WEEKDAY()
  • YEAR()

DAYOFMONTH()

Return the day of the month as a number from (1-31).

Prototype

string DAYOFMONTH(timestamp $timestamp)

Parameters

• timestamp - A date ("YYYY-MM-DD") or timestamp ("YYYY-MM-DD HH:MM:SS").

Return

The day portion of a date or timestamp, or NULL if there is an error, such as an invalid timestamp.

Example

SELECT OID, DAYOFMONTH(META(LastModified)) AS DayModified FROM User

See Also

DAY(), DAYOFYEAR(), WEEKDAY(), WEEK(), MONTH(), YEAR()

• < DAY()
• DAYOFYEAR() >