Re: a question about timestampadd month

hi julian on postgres I tried timestamp + interval, because it seems timetampadd is not supported: https://www.postgresql.org/docs/9.1/static/functions-datetime.html JIRA title is updated On Fri, Feb 17, 2017 at 12:51 AM, Julian Hyde wrote: > On Postgres did you try

Re: a question about timestampadd month

On Postgres did you try TIMESTAMPADD or did you try timestamp + interval? I ask because if we fix this, we are going to have to change the behavior of timestamp + interval. Also please change the JIRA case subject to something more descriptive. For the SQL standard, search for "ISO/IEC 9075-2”

Re: a question about timestampadd month

Hi Julian Thanks for you reply. I have confirmed on postgresql, it behaves exactly as mysql. For ansi SQL 92 I could find http://www.contrib.andrew.cmu.edu/~shadow/sql/ sql1992.txt, however for SQL 2011 I can't find a counterpart source. Can you please kindly show me a link? just to make sure

Re: a question about timestampadd month

Can you please log a JIRA case for this? It seems that we implement TIMESTAMPADD(unit, n, t) as “t + interval n unit”. E.g. timestampadd(MONTH, 1, DATE ‘2016-05-31’) translates to DATE ‘2016-05-31’ + INTERVAL ‘1’ MONTH. Similarly TIMESTAMPDIFF. So, can you please investigate whether we got