dynamobi/dynamobi — Issue #669: [FRG-203] Operations (+, -) with datetime and year month intervals are not supported
Author: dynamobi-build
Created: 2011-12-30 03:42:27+00:00
State: open
Labels: FRG

[reporter="angel", created="Mon, 11 Sep 2006 23:30:59 -0500 (GMT-05:00)"]
The following operations need to be enhanced to handle year-month intervals:

datetime - datetime (see StandardConvertletTable.convertDateTimeMinus)

datetime + or - interval

interval + or - datetime

The year month intervals are currently represented as # of months, datetime are in milliseconds, so operations with these two types need some work to get the results to be correct. Timezones

also need to be considered for datetime operations.

Testcases should be added to SqlOperatorTests.testPlusIntervalOperator, testMinusIntervalOperator, testMinusDateOperator (see TODOs).