OK, the "to_char" gets rid of the timezone extension. But the times still don't make sense.When I go to store this in a DB, I want to store the UTC time. How d I do that ?
Use the data type that represents exactly that, timestamptz. Using the timestamp data type is generally not what you want even if you can get the manipulation logic figured out.
David J.
