Search Postgresql Archives

new databases using a template.

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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-owner@xxxxxxxxxxxxxx [mailto:pgsql-general-owner@xxxxxxxxxxxxxx] On Behalf Of Rob Richardson
Sent: den 28 februari 2011 16:19
To: pgsql-general@xxxxxxxxxxxxxx
Cc: Tim Kelly
Subject: 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


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux