hongbin ma created CALCITE-1639: ----------------------------------- Summary: issue for timestampadd month Key: CALCITE-1639 URL: https://issues.apache.org/jira/browse/CALCITE-1639 Project: Calcite Issue Type: Bug Reporter: hongbin ma Assignee: Julian Hyde
in calcite, select timestampadd(MONTH,1,cast('2016-05-31' as timestamp)) will return 2016-07-01 00:00:00, and select timestampadd(MONTH,-1,cast('2016-03-31' as timestamp)) will return 2016-03-01 00:00:00 however in mysql, the last day of the next/previous month is always returned: mysql> select timestampadd(MONTH,1,'2016-05-31') ; +------------------------------------+ | timestampadd(MONTH,1,'2016-05-31') | +------------------------------------+ | 2016-06-30 | +------------------------------------+ 1 row in set (0.00 sec) mysql> select timestampadd(MONTH,-1,'2016-03-31') ; +-------------------------------------+ | timestampadd(MONTH,-1,'2016-03-31') | +-------------------------------------+ | 2016-02-29 | +-------------------------------------+ 1 row in set (0.00 sec) mysql> -- This message was sent by Atlassian JIRA (v6.3.15#6346)