Sabin Coanda wrote:
Hi there,
I'd like to format a time stamp with time zone as ISO pattern (e.g.
1999-01-08 04:05:06 -8:00)
I found the patterns for all the timestamp parts, from "Data Type Formatting
Functions" Postgresql documentation, excepting the numeric ISO time zone.
Please suggest the appropiate pattern for that.
If your DateStyle is set to ISO that's the default format. You don't
need to use to_char()
Or am I missing your point?
--
Richard Huxton
Archonet Ltd
---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings