sql> SELECT MONTH(time) AS month, time, target_obj,date(time) as time from trajectories where time between '2002-10-28' and '2003-11-03' AND (target_obj='Earth') GROUP BY MONTH(Time)
month time target_obj time
1 2003-01-01 00:00:00.0 EARTH 2003-01-01
2 2003-02-01 00:00:00.0 EARTH 2003-02-01
3 2003-03-01 00:00:00.0 EARTH 2003-03-01
4 2003-04-01 00:00:00.0 EARTH 2003-04-01
5 2003-05-01 00:00:00.0 EARTH 2003-05-01
6 2003-06-01 00:00:00.0 EARTH 2003-06-01
7 2003-07-01 00:00:00.0 EARTH 2003-07-01
8 2003-08-01 00:00:00.0 EARTH 2003-08-01
9 2003-09-01 00:00:00.0 EARTH 2003-09-01
10 2002-10-28 00:00:00.0 EARTH 2002-10-28
11 2002-11-01 00:00:00.0 EARTH 2002-11-01
12 2002-12-01 00:00:00.0 EARTH 2002-12-01
Elapsed time: 0.138 sec