timezone

timezone

am 01.08.2002 20:11:57 von angelo.rigo

how can i change the display format o a timezone field?
i want it to be brazilian format or latin american.

________________________________________
A busca mais veloz e precisa da internet. Acesse agora: http://www.zoom.com=
..br.



---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/users-lounge/docs/faq.html

Re: timezone

am 01.08.2002 20:14:48 von Josh Berkus

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


--=20
-Josh Berkus
Aglio Database Solutions
San Francisco


---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly