postgresql7.2
select entry_id,
to_char(entry_date, 'YYYY-MM-DD') as entry_date,
content,
to_char(posted_date , 'HH24:MI') as posted_time_pretty
from pinds_blog_entries
where package_id = :package_id
and draft_p = 'f'
and deleted_p = 'f'
order by entry_date desc, posted_date desc
limit $numberOfPosts