Angelo,
> how can i change the display format o a timezone field?
> i want it to be brazilian format or latin american.
Use the "to_char" function to format the time zone, for example:
SELECT to_char(some_date, 'DD.MM.YYYY');
some_date
-----------------
16.04.2002
--
-Josh Berkus
Aglio Database Solutions
San Francisco
