• unknown's avatar
    WL#530&531: TIMESTAMPADD, TIMESTAMPDIFF functions · 417354ea
    unknown authored
    Syntax for TIMESTAMPADD:
    
    TIMESTAMPADD(interval, integer_expression, datetime_expression)
    
    interval:= FRAC_SECOND | SECOND | MINUTE | HOUR | DAY | WEEK | MONTH | 
    QUARTER | YEAR
    
    Supported SQL_TSI_  prefix  (like SQL_TSI_SECOND)
    
    Syntax for TIMESTAMPDIFF:
    
    TIMESTAMPDIFF(interval, datetime_expression1, datetime_expression2)
    
    interval:= FRAC_SECOND | SECOND | MINUTE | HOUR | DAY | WEEK | MONTH | 
    QUARTER | YEAR
    
    Supported SQL_TSI_  prefix  (like SQL_TSI_SECOND)
    
    
    mysql-test/r/func_sapdb.result:
      Additional tests for timediff
    mysql-test/r/func_time.result:
      Tests for timestampadd, timestampdiff functions
    mysql-test/r/keywords.result:
      Test for new keywords
    mysql-test/t/func_sapdb.test:
      Additional tests for timediff
    mysql-test/t/func_time.test:
      Tests for timestampadd, timestampdiff functions
    mysql-test/t/keywords.test:
      Test for new keywords
    sql/item_create.cc:
      WL#530&531: TIMESTAMPADD, TIMESTAMPDIFF functions
    sql/item_create.h:
      WL#530&531: TIMESTAMPADD, TIMESTAMPDIFF functions
    sql/item_timefunc.cc:
      WL#530&531: TIMESTAMPADD, TIMESTAMPDIFF functions
    sql/item_timefunc.h:
      WL#530&531: TIMESTAMPADD, TIMESTAMPDIFF functions
    sql/lex.h:
      WL#530&531: TIMESTAMPADD, TIMESTAMPDIFF functions
    sql/sql_yacc.yy:
      WL#530&531: TIMESTAMPADD, TIMESTAMPDIFF functions
    417354ea
func_sapdb.result 8.17 KB