title: MySQL - Convert ISO-8601 Duration to Interval for DATE_ADD
body: <p>I have two fields stored in a database, one of which contains a datetime and the other which contains a string representing a duration in ISO-8601 format (e.g. "P1MT2H"). I want to be able to add the duration to the datetime column in SQL and it seems like I should be able to do this using <code>DATE_ADD</code> but I don't know if there's a good way to convert it to an interval. I would prefer to not to have to define my own sql function that parses out the interval if possible.</p>