Thread: number of days in a month

number of days in a month

From
Cwhisperer
Date:
Hello,
 in php I can find out the number of days within a month :    march 31    april 30    mai   31    ....
does it exist a date function  to determine the number of days in aSelect, knowing a specifique date ?

-- 
Best regards,Cwhisperer                          mailto:Cwhisperer@vo.lu




Re: number of days in a month

From
Kaare Rasmussen
Date:
>  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