{"issue":{"milestone":null,"title":"[FRG-203] Operations (+, -) with datetime and year month intervals are not supported","created_at":"2011-12-30T03:42:27Z","user":{"login":"dynamobi-build","id":1123017,"url":"https://api.github.com/users/dynamobi-build","avatar_url":"https://secure.gravatar.com/avatar/cb215b3d786be20761071a562a56af64?d=https://a248.e.akamai.net/assets.github.com%2Fimages%2Fgravatars%2Fgravatar-140.png","gravatar_id":"cb215b3d786be20761071a562a56af64"},"labels":[{"name":"FRG","url":"https://api.github.com/repos/dynamobi/dynamobi/labels/FRG","color":"1f8f0d"}],"updated_at":"2011-12-30T03:42:27Z","state":"open","id":2686201,"closed_at":null,"html_url":"https://github.com/dynamobi/dynamobi/issues/669","pull_request":{"patch_url":null,"html_url":null,"diff_url":null},"body":"<b><i>[reporter=\"angel\", created=\"Mon, 11 Sep 2006 23:30:59 -0500 (GMT-05:00)\"]</i></b>\nThe following operations need to be enhanced to handle year-month intervals:<br/>\ndatetime - datetime (see StandardConvertletTable.convertDateTimeMinus)<br/>\ndatetime + or - interval<br/>\ninterval + or - datetime<br/>\n<br/>\nThe 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<br/>\nalso need to be considered for datetime operations.<br/>\n<br/>\nTestcases should be added to SqlOperatorTests.testPlusIntervalOperator, testMinusIntervalOperator, testMinusDateOperator (see TODOs).<br/>\n<br/>\n<br/>\n<br/>\n","number":669,"url":"https://api.github.com/repos/dynamobi/dynamobi/issues/669","comments":0,"assignee":null},"action":"opened"}