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