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@sirius-images.com Sirius Images Inc.
http://www.sirius-images.net/users/yohans http://www.sirius-images.com
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
