Обсуждение: Get days between two dates?
Good morning, Is there an existing method to get days between two dates? For example, select '2010-01-01'::date - '1999-10-12'::date Returns how many days. Thank you, -- Lu Ying
On 01/31/2011 11:33 AM, Oliveiros d'Azevedo Cristina wrote:
> Doesn't the SELECT you indicated do what you need?
Ok, I figured out:
age() + date_part(...) would be able to get it:
select date_part('day', age(date1::timestamp, date2::timestamp) )
--
Lu Ying
>
>
> ----- Original Message ----- From: "Emi Lu" <emilu@encs.concordia.ca>
> To: <pgsql-sql@postgresql.org>
> Sent: Monday, January 31, 2011 3:50 PM
> Subject: [SQL] Get days between two dates?
>
>
>> Good morning,
>>
>> Is there an existing method to get days between two dates?
>>
>> For example,
>>
>> select '2010-01-01'::date - '1999-10-12'::date
>>
>> Returns how many days.
>>
>> Thank you,
>>
>> --
>> Lu Ying
>>
>> --
>> Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
>> To make changes to your subscription:
>> http://www.postgresql.org/mailpref/pgsql-sql
--
Emi Lu, ENCS, Concordia University, Montreal H3G 1M8
emilu@encs.concordia.ca +1 514 848-2424 x5884
On Mon, Jan 31, 2011 at 10:50:43AM -0500, Emi Lu wrote: > Good morning, > > Is there an existing method to get days between two dates? > > For example, > > select '2010-01-01'::date - '1999-10-12'::date > > Returns how many days. > > Thank you, > > -- > Lu Ying > Didn't you just answer your own question? Cheers, Ken
Doesn't the SELECT you indicated do what you need? Best, Oliveiros ----- Original Message ----- From: "Emi Lu" <emilu@encs.concordia.ca> To: <pgsql-sql@postgresql.org> Sent: Monday, January 31, 2011 3:50 PM Subject: [SQL] Get days between two dates? > Good morning, > > Is there an existing method to get days between two dates? > > For example, > > select '2010-01-01'::date - '1999-10-12'::date > > Returns how many days. > > Thank you, > > -- > Lu Ying > > -- > Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-sql
That's precisely what I think.. :-| ----- Original Message ----- From: "Kenneth Marshall" <ktm@rice.edu> To: "Emi Lu" <emilu@encs.concordia.ca> Cc: <pgsql-sql@postgresql.org> Sent: Monday, January 31, 2011 4:39 PM Subject: Re: [SQL] Get days between two dates? > On Mon, Jan 31, 2011 at 10:50:43AM -0500, Emi Lu wrote: >> Good morning, >> >> Is there an existing method to get days between two dates? >> >> For example, >> >> select '2010-01-01'::date - '1999-10-12'::date >> >> Returns how many days. >> >> Thank you, >> >> -- >> Lu Ying >> > > Didn't you just answer your own question? > > Cheers, > Ken > > -- > Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-sql
On 01/31/2011 04:50 PM, Emi Lu wrote: > Good morning, > > Is there an existing method to get days between two dates? > > For example, > > select '2010-01-01'::date - '1999-10-12'::date > > Returns how many days. > > Thank you, > > -- > Lu Ying > Hi ! Yes there is : date '2001-10-01' - date '2001-09-28' returns integer '3' (days) as said here : http://www.postgresql.org/docs/8.4/interactive/functions-datetime.html -- Tovo J. RABEMANANTSOA INRA - UR1263 EPHYSE 71, Av. Edouard Bourlaux F-33140 Villenave d'Ornon - France Téléphone : +33 5 57 12 24 09