[
https://issues.apache.org/jira/browse/QPID-7177?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Keith Wall updated QPID-7177:
-----------------------------
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:
# now()
# dateadd(date-part, numeric-expression, date-expression)
# date(iso-8601-date-str)
was:Allow a query's where clause to include now() and currentUser(). This
will allow the Operator to more easily re-use queries over time, or share
queries amongst his team.
> Add support for where clauses including time/date based functions such as
> now(), dateadd(), date()
> --------------------------------------------------------------------------------------------------
>
> Key: QPID-7177
> URL: https://issues.apache.org/jira/browse/QPID-7177
> Project: Qpid
> Issue Type: Improvement
> Components: Java Broker
> Reporter: Keith Wall
> Fix For: qpid-java-6.1
>
>
> 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:
> # now()
> # dateadd(date-part, numeric-expression, date-expression)
> # date(iso-8601-date-str)
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]