Adding Days to Date

user06209

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

MarkSnodgrass

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

SELECT DATE_ADD(mydatecolumn, INTERVAL 10 DAY)
FROM MyTable

DataMaven

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.