Skip site navigation (1) Skip section navigation (2)

Re: how to get a number of seconds in some interval ?

From: "Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com>
To: "Shane Ambler" <pgsql(at)sheeky(dot)biz>
Cc: "Achilleas Mantzios" <achill(at)matrix(dot)gatewaynet(dot)com>, pgsql-admin(at)postgresql(dot)org, "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>, "Julius Tuskenis" <julius(at)nsoft(dot)lt>
Subject: Re: how to get a number of seconds in some interval ?
Date: 2008-05-13 08:48:32
Message-ID: dcc563d10805130148r4d24fe94s18e71921d6bd121a@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-admin
On Tue, May 13, 2008 at 2:42 AM, Shane Ambler <pgsql(at)sheeky(dot)biz> wrote:
> Scott Marlowe wrote:
>
>> True.  But that's only because it doesn't have a date to work against.
>>  If you run:
>>
>> select '2007-02-01 12:00:00'::timestamp + '1 month'::interval;
>> you get: 2007-03-01 12:00:00
>>
>> If you run:
>> select '2007-03-01 12:00:00'::timestamp + '1 month'::interval;
>> you get:  2007-04-01 12:00:00
>>
>> Then, if we run:
>>  select ('2007-03-01 12:00:00'::timestamp + '1 month'::interval) -
>> '2007-03-01 12:00:00'::timestamp;
>> we get: 31 days
>>
>> But if we run:
>>  select ('2007-02-01 12:00:00'::timestamp + '1 month'::interval) -
>> '2007-02-01 12:00:00'::timestamp;
>> we get: 28 days
>>
>> So, I'm not sure how many days a month has.
>
> Try looking at a calendar.;-)

Sorry, didn't realize I'd need to explain my joke.  Thought it was
pretty obvious.  Next time I'll throw a smiley in there.

In response to

pgsql-admin by date

Next:From: Travis SmithDate: 2008-05-13 13:45:19
Subject: EDB database link to Oracle
Previous:From: Shane AmblerDate: 2008-05-13 08:42:41
Subject: Re: how to get a number of seconds in some interval ?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group