Tom Azernour avatar
Written by Tom Azernour
Updated over a week ago

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 the created_at field value set to 23h59m59s the same day. If created_at is equal to 2023-02-23T15:39:21Z then END_OF_DAY(created_at) returns 2023-02-23T23:59:59Z.

  • END_OF_DAY() is equal to END_OF_DAY(NOW())

Did this answer your question?