oracle8.1.6
select trunc(entry_date, 'month') as month_date,
to_char(trunc(entry_date, 'month'), 'fmMonthfm, YYYY')
as date_pretty,
to_char(trunc(entry_date, 'month'), 'YYYY/MM/')
as month_url_stub,
'' as url
from pinds_blog_entries
where draft_p = 'f'
and package_id = :package_id
group by trunc(entry_date, 'month')
order by month_date desc