Todd P Marek <affe23(at)somahq(dot)com> writes:
> I am using the to_char function to make the times human friendly
> to_char(class_schedule.endtime, 'HH:MI:SS AM')
> which returns
> 06:30:00 AM - 07:30:00 AM
> I am really looking to get it outputting like this.
> 6:30 AM - 7:30 AM
> I have looked through the documentation and haven't found anything to
> do this in postgres.
I think you want 'FMHH:MI AM' ... if not, you'd better be more specific
about what you want.
regards, tom lane