Type: Function
Function: BEGINNING_OF_HOUR
Syntax: BEGINNING_OF_HOUR(datetime)
Description: Returns a datetime corresponding to the beginning of the hour (minutes and seconds set to zero) for the provided datetime or NOW if no value is provided.
Sample usage:
BEGINNING_OF_HOUR(created_at)returns thecreated_atfield value set at the beginning of the hour (minutes and seconds set to zero) Ifcreated_atis equal to2023-02-23T15:39:21ZthenBEGINNING_OF_HOUR(created_at)returns2023-02-23T15:00:00Z.BEGINNING_OF_HOUR()is equal toBEGINNING_OF_HOUR(NOW())