Truncate date to minute | DATE_TRUNCATE_TO_MINUTE

Syntax

DATE_TRUNCATE_TO_MINUTE( [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 truncated DATE

Description

Set the seconds and milliseconds values of a DATE to 0.

Examples

DATE_TRUNCATE_TO_MINUTE("2017-08-30T17:36:23.700Z") # returns DATE("2017-08-30T17:36:00.000Z")