Maybe try something like:
SELECT to_char(mytable.date + mytable.time, 'HH:MIAM');
That puts your separate date and time fields together into a timestamp, then
you can use to_char.
If you don't have a mytable.date, I think you could just do:
SELECT to_char(CURRENT_DATE + mytable.time, 'HH:MIAM');
In formatting the time part, I don't think it will look at the date part at
all. It might not matter what the date actually is in there.
On Wednesday 17 January 2001 12:20, Jeffery L Post wrote:
> Well I finaly got around to trying the to_char function. And I am having
> difficulty getting it to do what I want elegantly.
>
> Here is the situation...
> I am tracking the time that an event occurs in a column of type time.
> (seperate column for date). I want to display the time of the event in a
> fool proof HH:MM (AM | PM) format. As far as I can tell the to_char()
> function is not overloaded for the time type just timestamp.
>
> How do I format a column of type time to HH:MM AM | PM ?
> I belive the now() function returns a timestamp. but I need a strict time
> datatype example.
>
> Thanks again
> Jeff Post
> University of Wisconsin - Milwaukee
--
-------- Robert B. Easter reaster@comptechnews.com ---------
-- CompTechNews Message Board http://www.comptechnews.com/ --
-- CompTechServ Tech Services http://www.comptechserv.com/ --
---------- http://www.comptechnews.com/~reaster/ ------------
