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 |