oracle8.1.6
select to_char(entry_date, 'J') as entry_date_julian
from pinds_blog_entries
where package_id = :package_id
and draft_p = 'f'
and deleted_p = 'f'
group by to_char(entry_date, 'J')
select to_char(entry_date, 'J') as entry_date_julian
from pinds_blog_entries e,
acs_objects o,
users u
where package_id = :package_id
and o.object_id = e.entry_id
and u.user_id = o.creation_user
and u.screen_name = :screen_name
and draft_p = 'f'
and deleted_p = 'f'
group by to_char(entry_date, 'J')