How can I "select ('2006-01-01 9:00:00+02' at time zone 'GMT')::timestamp;" where instead of GMT it has the local time zone of the machine I am running it on (which varies between my machines)? I dont want to hard code the timezone of the machine into the query.. I want to pick it up from the environment, but cant figure out how :-( -- Peter Nixon http://www.peternixon.net/ PGP Key: http://www.peternixon.net/public.asc