[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).
[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).