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
0
Comments
-
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 toany users posts that helped you.
**Please mark as accepted the ones who solved your issue.0 -
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
Check out my video!
**Say "Thanks" by clicking the heart in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"0
Categories
- 7.3K All Categories
- 13 Getting Started in the Community
- 134 Beastmode & Analytics
- 1.8K Data Platform & Data Science
- 52 Domo Everywhere
- 2K Charting
- 994 Ideas Exchange
- 894 Connectors
- 236 Workbench
- 342 APIs
- 76 Apps
- 18 Governance & Productivity
- 233 Use Cases & Best Practices
- 49 News
- 473 Onboarding
- 570 日本支部