[GENERAL] converting timstamptz to local time zone

2006-03-30 Thread Peter Nixonn
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 envir

[GENERAL] Weird join result

2006-08-16 Thread Peter Nixonn
Hi Guys I am getting a result for an JOIN that I think is wrong. Maybe its my understanding that is wrong here however, so please be gentle :-) The "phones" table contains a list of phone numbers and an associated customer ID. The radacct table contains a list of all calls made (RADIUS Accounting