Dennis Gearon <gearond(at)sbcglobal(dot)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