Show gaps between dates in MySQL

Vote count:

0

How can I show the remaining/complementary dates in mysql?

For example in my table that has 2 columns, a snapshot for

from_date>14-06-2014 and to_date<01-07-2014

would give this output:

From date   || To_date
15-06-2014  || 20-06-2014
23-06-2014  || 27-06-2014 
29-06-2014  || 30-06-2014 

I would like to be able to show the dates that we have a gap and no records exist, like this:

21-06-2014 - 23-06-2014
28-06-2014 

Is this possible? Thank you

asked 1 min ago

Kabamaru

2,253