I would thought it would be an obvious try:
cnagy=> select to_char(now(), 'HH:MM AM');
to_char
----------
04:10 PM
(1 row)
HTH,
Csaba.
On Tue, 2004-10-05 at 16:32, Todd P Marek wrote:
> Hello-
>
> I am in the process of translating a site using mysql as the
> backendover to postgres. I have a lot of time data that I would like
> todisplay to the user in the form of a schedule.
>
> 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 andhaven't found anything to
> do this in postgres. I am going to have todo this formating in the
> application layer?
>
> Thanks
> Todd Marek
>
> "If you think you understand somethingit's habit."
> --Gary Kraftsow--