to_char

Hi again, thanks for all your responses, now that I've taken a better look
at my problem, let me rephrase my question

I'm moving an app. from oracle to postgres, and I'm having problems with
the data type "time" I was able to format oracle's datatype "date" to
anything I'd like using to_char function, but postgres does not have a
version of the function that acceps "time" as a parameter. When I try to
cast time explicitly to timestamp, postgres complains about not allowing
that type casting.

In brief, I want to be able to display my time data in to ways:
24:MI and 24MI

How can I accomplish that?

TIA

--Yohans

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Yohans Mendoza System Analyst
yohans(at)sirius-images(dot)com Sirius Images Inc.
http://www.sirius-images.net/users/yohans http://www.sirius-images.com
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~