Day of Month | DATE_DAY_OF_MONTH

Syntax

DATE_DAY_OF_MONTH( [value = CURRENT_DATE()] )

Parameters

value
A DATE value. If the value is not a DATE, it will be converted to one with the DATE operation.

Return Value

Returns the UTC date value of the VALUE as an INTEGER

Description

Get the day of the month of a DATE

Examples

DATE_DAY_OF_MONTH("2017-08-30T17:36:23.000Z") # returns 30