Good. The second type of interval specified by the SQL standard is
INTERVAL 'd hh:mm:ss' DAY TO SECOND, where
d is the number of days,
hh is the number of hours,
mm is the number of minutes and
ss is the number of seconds.
This interval can also be applied with a date/timestamp column to add/subtract a certain period of time:
launched + INTERVAL '1 2:05:20' DAY TO SECOND
The above query will add 1 day, 2 hours, 5 minutes and 20 seconds to the timestamp in the column
launched and return it as a result. So for example the timestamp
2010-04-01 21:58:00+02 would be turned into
Again, MySQL has an alternative syntax:
INTERVAL '1 2:05:20' DAY_SECOND.