Postgres Pro
Downloads
Home   >   mailing lists

Re: number of days in a month - Mailing list pgsql-sql

From Kaare Rasmussen
Subject Re: number of days in a month
Date
Msg-id 01051120155301.00699@bering
Whole thread Raw
In response to number of days in a month  (Cwhisperer <Cwhisperer@vo.lu>)
List pgsql-sql
Tree view 
>  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@webline.dk

pgsql-sql by date:

Previous
From: Roberto Mello
Date:
Subject: Re: Is this possible?
Next
From: Mathijs Brands
Date:
Subject: Re: Re: How to store gif or jpeg? Thanks!