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