Arrival At Pluto

New Horizons is scheduled to arrive at the PLANET Pluto (don’t give me any of that dwarf or minor crap) on:

select DATE_ADD(date(‘2015-06-02’), INTERVAL 42 DAY) as ‘Arrival at Pluto’;

Kind of sad that I thought it would be easier to write the query than count the days manually, huh?

WordPress likes to help by adding weird apostrophes, so:

select DATE_ADD(date('2015-06-02'), INTERVAL 42 DAY) as 'Arrival at Pluto';

This yields 2015-07-14

This entry was posted in MySQL and tagged , , , , , . Bookmark the permalink.

Leave a Reply

Your email address will not be published.

Enter Captcha Here : *

Reload Image