Adding Days to Date

user06209
user06209 Member
in Magic ETL

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 Coach

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

    SELECT DATE_ADD(mydatecolumn, INTERVAL 10 DAY)
    FROM MyTable
    **Check out my Domo Tips & Tricks Videos

    **Make sure to <3 any users posts that helped you.
    **Please mark as accepted the ones who solved your issue.
  • DataMaven
    DataMaven Coach

    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.  

    DataMaven
    Breaking Down Silos - Building Bridges
    **Say "Thanks" by clicking a reaction in the post that helped you.
    **Please mark the post that solves your problem by clicking on "Accept as Solution"

Categories