Hi, I'm trying to create a new database by using a template database. But it is not possible. The error code is that some one is using the template, but no one is using it. I'm using PgAdmin III ver 1.1.0. Has some one seen something like this? /Paul
________________________________ From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Rob Richardson Sent: den 28 februari 2011 16:19 To: pgsql-general@postgresql.org Cc: Tim Kelly Subject: Re: [GENERAL] 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
