[QPID-7177] Add support for where clauses including time/date based functions such as now(), dateadd(), date()

• Type: Improvement
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: qpid-java-6.1
• Component/s: Broker-J
• Assignee: Robert Godfrey
• Reporter: Keith Wall
• Created: 31/Mar/16 15:54
• Updated: 02/Oct/19 19:22
• Resolved: 19/Apr/16 09:03

Description

Allow a query's where clause to include expressions involving dates or datetimes.. This will allow the Operator to easily create queries that can be used over time without modification.

Inspiration can be drawn from SQL vendors, with functions like:

1. now()
2. dateadd(date-part, numeric-expression, date-expression)
3. date(iso-8601-date-str)