DAY_ONLY

Returns a date representing the day portion of "dateTime_expression".

Syntax

DAY_ONLY ( dateTime_expression )

Example

DAY_ONLY ( '2012-02-29T23:00:01Z' )

Result

2012-02-29

Parent topic: Date Functions