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--