Re: [PERFORM] [ADMIN] Messed up time zones

2012-08-03 Thread Laszlo Nagy
So you took two distinct points in time, threw away some critical information, and are surprised why they are now equal? Well, I did not want to throw away any information. The actual representation could be something like: "2012-11-04 01:30:00-08 in Europe/Budapest, Winter time" and "2012-

Re: [PERFORM] [ADMIN] Messed up time zones

2012-08-03 Thread Steve Crawford
On 08/03/2012 10:21 AM, Laszlo Nagy wrote: All the above are the exact same point in time merely stated as relevant to each location. Note that given a timestamp with time zone and a zone, PostgreSQL returns a timestamp without time zone (you know the zone since you specified it). Yes, I kn

Re: [PERFORM] [ADMIN] Messed up time zones

2012-08-03 Thread Laszlo Nagy
All the above are the exact same point in time merely stated as relevant to each location. Note that given a timestamp with time zone and a zone, PostgreSQL returns a timestamp without time zone (you know the zone since you specified it). Yes, I know the zone. But I don't know the offset fro