Dennis Gearon <gear...@sbcglobal.net> writes: > What I want is to be able to insert into my project's database, times > given by anybody anywhere on the planet (the SUBMITTER), add the appropriate > timezone in the insert statement so that it in 'GMT/UMT' neutral'. I believe > this is the way Postgres does it, storing times in GMT time.
So just do it. What do you need to_timestamp for? The basic timestamptz input function is far more likely to get it right for input that's not in a precise predetermined format. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general