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
