DATETIME_EQUAL

Description

DATETIME_EQUAL takes two datetime values and returns true if they refer to the exact same point in time, including the time component.

If you only need to compare calendar dates without a time component, use DATE_EQUAL.

Example

DATETIME_EQUAL(NOW(), '2019-05-15T09:00:00+00:00')

This returns true only if the current date and time is exactly 15 May 2019 at 09:00 UTC.

Last updated

Was this helpful?