Vay
Reputation: 117
Add days to a mysql datetime row
How can I add 14 days to that: DATE_ADD(p.since, INTERVAL 1 YEAR) ?
I want to check if the row p.since is exactly 1 year and 14 days old in MySQL.
Upvotes: 1
Views: 1136
Answers (1)
zerkms
Reputation: 254886
Just nest it to another DATE_ADD:
DATE_ADD(DATE_ADD(p.since, INTERVAL 1 YEAR), INTERVAL 14 DAY)
Upvotes: 3
Related Questions
- MySQL add days to a date
- How can I add days to a date in MYSQL in a query
- How to add days in MySQL on date column?
- How to add days to a date in mysql
- MySQL Datetime add days
- MySQL how to add days to column
- Add a one day to datetime field in mysql table
- Add days to a date
- Add day to dateTime in query
- Adding days to a date