Adding Days to Date

I am trying to add 7 Days to my date in SQL Transform.  When I simply do Date + 7, the date is larger than the end of the month it shows as a larger number(2019/08/30 becomes 20190837). How do I add days to date.

 

Select date + 7

from table

Comments

  • MarkSnodgrass
    MarkSnodgrass Portland, Oregon 🔴

    Assuming you are using MySQL, you would do this to add 7 days

    SELECT DATE_ADD(mydatecolumn, INTERVAL 10 DAY)
    FROM MyTable
  • Are you doing any transforms that can't be done in Magic ETL?  It has a tile for date operations, which handles this really well.