Re: Thoroughly confused about time zones

I think maybe I’m making things much more difficult than they need to be.  I tried this:

select cast (extract(epoch from ('2010-3-14 12:00'::timestamp - '2010-3-13 12:00'::timestamp)) as integer) / 60 / 60

and got 24.  The difference between timestamps without time zones is 24 hours, even though the interval spanned a time change.

But when I tried this:

select cast (extract(epoch from ('2010-3-14 12:00'::timestamptz - '2010-3-13 12:00'::timestamptz)) as integer) / 60 / 60

I got 23, showing that even if I did not specify what time zone I’m talking about, I got the correct answer.

RobR