[jboss-jira] [JBoss JIRA] Commented: (JBRULES-497) Joda datetime API integration

[Peter Hilton (JIRA)]

    [ https://jira.jboss.org/jira/browse/JBRULES-497?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12479647#action_12479647 ] 

Peter Hilton commented on JBRULES-497:
--------------------------------------

Note that what we are asking for looks like the way that Postgres SQL works with dates and 'intervals' - http://www.postgresql.org/docs/8.4/static/functions-datetime.html

It lets you construct an interval from a string like '2 months' and lets you add it to a date to get another date, so you can do comparisons like (date1 < date2 + interval '2 months')

On another topic, I saw 'working days' mentioned on the mailing list, which would be especially useful but I fear hides a tricky internationalisation issue. The 'working week' is not Monday to Friday everywhere: http://en.wikipedia.org/wiki/Workweek

> Joda datetime API integration
> -----------------------------
>
>                 Key: JBRULES-497
>                 URL: https://jira.jboss.org/jira/browse/JBRULES-497
>             Project: Drools
>          Issue Type: Feature Request
>      Security Level: Public(Everyone can see) 
>          Components: All
>            Reporter: Michael Neale
>            Assignee: Mark Proctor
>
> http://joda-time.sourceforge.net/userguide.html
> Would be VERY nice to have this working at the parser level to parser dates in a string, but also possibly in our expression language to overload "+", "-" etc for subtracting dates/fragments of dates:
> eg:
> today - "6Months" 

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira