DATE_EQUAL

Description

DATE_EQUAL takes two dates and returns true if they refer to the same calendar date (day, month, year), ignoring any time component.

If you need to compare two values including their time component, use DATETIME_EQUAL.

Example

e is Entity
DATE_EQUAL(e.date_of_founding, '2016-02-29')

This returns true if the entity was founded on 29 February 2016.

Last updated

Was this helpful?