Re: Formatting a month in query output

On Thu, 2005-01-27 at 12:31 +1100, Alexander Borkowski wrote:
> Sorry, I totally missed the crucial point there. How about
>
> select date_trunc('month', date) as sort_month, to_char(date,'Mon YYYY')
> as month, count(num) as num, sum(hrs_total) as hours from flights group
> by sort_month, month order by sort_month asc;
>

flightlog=> select date_trunc('month', date) as sort_month, to_char
(date, 'Mon YYYY') as month, count(num) as num, sum(hrs_total) as hours
from flights group by sort_month, month order by sort_month asc;

     sort_month      |  month   | num | hours
---------------------+----------+-----+-------
 2003-08-01 00:00:00 | Aug 2003 |   4 |   5.6
 2003-09-01 00:00:00 | Sep 2003 |   2 |   3.5
 2003-10-01 00:00:00 | Oct 2003 |   2 |   4.2
 2003-11-01 00:00:00 | Nov 2003 |  10 |  17.7
 2003-12-01 00:00:00 | Dec 2003 |  10 |  16.4
 2004-01-01 00:00:00 | Jan 2004 |   9 |  13.3
 2004-02-01 00:00:00 | Feb 2004 |   6 |   9.3
 2004-03-01 00:00:00 | Mar 2004 |  10 |  12.2
 2004-04-01 00:00:00 | Apr 2004 |  11 |  17.4
 2004-05-01 00:00:00 | May 2004 |   5 |   7.3
 2004-06-01 00:00:00 | Jun 2004 |  10 |  16.5
 2004-07-01 00:00:00 | Jul 2004 |   8 |  10.4
 2004-08-01 00:00:00 | Aug 2004 |   8 |  13.0
 2004-09-01 00:00:00 | Sep 2004 |   8 |  10.3
 2004-10-01 00:00:00 | Oct 2004 |   2 |   2.5
 2004-11-01 00:00:00 | Nov 2004 |  10 |  17.4
 2004-12-01 00:00:00 | Dec 2004 |   5 |   8.9
 2005-01-01 00:00:00 | Jan 2005 |   4 |   6.0
(18 rows)

This would be perfect if we could get rid of that first column and only
display the rest. Is that possible?

Thanks for all the help.

--
Rodolfo J. Paiz <rpaiz@simpaticus.com>