> > > Every example here starts, at its core, with to_timestamp. That function > returns a timestamp *with* time zone so of-course the current timezone > setting will influence it. Stop using it - it doesn't do what you want. > > If you cast directly to a timestamp *without* time zone you can take > advantage of the many formats PostgreSQL supports. > > See: > http://www.postgresql.org/docs/9.0/interactive/datatype-datetime.html#DATATYPE-DATETIME-DATE-TABLEfor > supported formats. Note also that you can use "set datestyle" to match > your MDY or DMY date formatting. > > Fair enough: to_timestamp doesn't do what I want, I must resort to casting.
But it's rather unfortunate that a to_timestamp() function doesnt actually parse a "timestamp" (which, is a alias to "timestamp without timezone", at least since PG 7.3) . BTW, the "set datestyle" workaround can be umpractical in some scenarios (case in point: I have a view that returns some column as "timestamp" by doing that parsing from a text colum ) I even can't put a "SET DATESTYLE" (or a SET TIMEZONE=UTC)" in a function, unless I make it VOLATILE, which I certainly would not like. Regards Hernán J. González
