[GENERAL] Mailing

[Todd P Marek]

Hello-

I am in the process of translating a site using mysql as the backend over to postgres. I have a lot of time data that I would like to display 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 and haven't found anything to do this in postgres. I am going to have to do this formating in the application layer?

Thanks
Todd Marek

"If you think you understand something it's habit."
--Gary Kraftsow--