Type: Function
Function: END_OF_DAY
Syntax: END_OF_DAY(datetime)
Description: Returns a datetime corresponding to the end of day (hour set to 23, minutes and seconds set to 59) for the provided datetime or NOW if no value is provided.
Sample usage:
END_OF_DAY(created_at)returns thecreated_atfield value set to 23h59m59s the same day. Ifcreated_atis equal to2023-02-23T15:39:21ZthenEND_OF_DAY(created_at)returns2023-02-23T23:59:59Z.END_OF_DAY()is equal toEND_OF_DAY(NOW())