[SQL] number of days in a month

2001-05-11 Thread Cwhisperer
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 a Select, knowing a specifique date ? -- Best regards, Cwhisperer mailto:[EMAIL P

Re: [SQL] number of days in a month

2001-05-11 Thread Kaare Rasmussen
> 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 Datatshirts, merch