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 |