Mailing

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


    <fontfamily><param>Verdana</param><smaller>06:30:00 AM - 07:30:00 AM</smaller></fontfamily>


I am really looking to get it outputting like this.


<fontfamily><param>Verdana</param><smaller>    6:30 AM - 7:30 AM


</smaller></fontfamily>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<fontfamily><param>Verdana</param><smaller>


</smaller></fontfamily><italic>"If you think you understand something
it's habit."

--Gary Kraftsow--</italic>
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--