[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 PROTECTED]



---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/users-lounge/docs/faq.html



[SQL] Case

2001-05-14 Thread Cwhisperer

Hello,

what's wrong when you receive this message from an select statement
: CASE types "date" and "text" not matched 

thank you for any help  

-- 
Best regards,
 Cwhisperer  mailto:[EMAIL PROTECTED]



---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]