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