Date and Time Operators

When an expression token contains a value or attribute with a date/time data type, the following operators can be used within those expression tokens. Note that there are time and date operators for date and time as a whole (date/time), and for each unit of time (date, time, year, month, day, hour, minute, second) separately:

Overall Date/Time Operators

Operator Meaning
QOP_DATETIME_EQ date and time is
QOP_DATETIME_NEQ date and time is not
QOP_DATETIME_GT date and time is after
QOP_DATETIME_LT date and time is before
QOP_DATETIME_GTE date and time is on or after
QOP_DATETIME_LTE date and time is on or before

Date Operators

Operator Meaning
QOP_DATE_EQ date is
QOP_DATE_NEQ date is not
QOP_DATE_GT date is after
QOP_DATE_LT date is before
QOP_DATE_GTE date is on or after
QOP_DATE_LTE date is on or before

Time Operators

Operator Meaning
QOP_TIME_EQ time is
QOP_TIME_NEQ time is not
QOP_TIME_GT time is after
QOP_TIME_LT time is before
QOP_TIME_GTE time is on or after
QOP_TIME_LTE time is on or before

Year Operators

Operator Meaning
QOP_YEAR_EQ year is
QOP_YEAR_NEQ year is not
QOP_YEAR_GT year is after
QOP_YEAR_LT year is before
QOP_YEAR_GTE year is on or after
QOP_YEAR_LTE year is on or before

Month Operators

Operator Meaning
QOP_MONTH_EQ month is
QOP_MONTH_NEQ month is not
QOP_MONTH_GT month is after
QOP_MONTH_LT month is before
QOP_MONTH_GTE month is on or after
QOP_MONTH_LTE month is on or before

Day Operators

Operator Meaning
QOP_DAY_EQ day is
QOP_DAY_NEQ day is not
QOP_DAY_GT day is after
QOP_DAY_LT day is before
QOP_DAY_GTE day is on or after
QOP_DAY_LTE day is on or before

Hour Operators

Operator Meaning
QOP_HOUR_EQ hour is
QOP_HOUR_NEQ hour is not
QOP_HOUR_GT hour is after
QOP_HOUR_LT hour is before
QOP_HOUR_GTE hour is on or after
QOP_HOUR_LTE hour is on or before

Minute Operators

Operator Meaning
QOP_MINUTE_EQ minute is
QOP_MINUTE_NEQ minute is not
QOP_MINUTE_GT minute is after
QOP_MINUTE_LT minute is before
QOP_MINUTE_GTE minute is on or after
QOP_MINUTE_LTE minute is on or before

Second Operators

Operator Meaning
QOP_SECOND_EQ second is
QOP_SECOND_NEQ second is not
QOP_SECOND_GT second is after
QOP_SECOND_LT second is before
QOP_SECOND_GTE second is on or after
QOP_SECOND_LTE second is on or before