[
https://issues.apache.org/jira/browse/QPID-7177?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15244583#comment-15244583
]
ASF subversion and git services commented on QPID-7177:
-------------------------------------------------------
Commit 1739559 from [~k-wall] in branch 'java/trunk'
[ https://svn.apache.org/r1739559 ]
QPID-7177: [Java Broker] Configured Object search - add DATE_ADD, TO_STRING
* DATE_ADD takes a ISO 8601 format duration e.g. -PT10H (minus ten hours)
* TO_STRING can format objects using an optional printf style formatting. For
dates an optional timezone may be included too.
> 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]
