Re: number of days in a month

From: Kaare Rasmussen <kar(at)webline(dot)dk>
To: Cwhisperer <Cwhisperer(at)vo(dot)lu>, pgsql-sql(at)postgresql(dot)org
Subject: Re: number of days in a month
Date: 2001-05-11 18:15:53
Message-ID: 01051120155301.00699@bering
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

> does it exist a date function to determine the number of days in a
> Select, knowing a specifique date ?

January, 2001:

select '2001-2-1'::datetime - '2001-1-1'::datetime;

--
Kaare Rasmussen --Linux, spil,-- Tlf: 3816 2582
Kaki Data tshirts, merchandize Fax: 3816 2501
Howitzvej 75 Åben 14.00-18.00 Web: www.suse.dk
2000 Frederiksberg Lørdag 11.00-17.00 Email: kar(at)webline(dot)dk

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message webb sprague 2001-05-11 19:40:06 WAL logs eating my diskspace!!
Previous Message Roberto Mello 2001-05-11 17:24:17 Re: Is this possible?