[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-sql
Subject:    Re: [SQL] number of days in a month
From:       Kaare Rasmussen <kar () webline ! dk>
Date:       2001-05-11 18:15:53
[Download RAW message or body]

>  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

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

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

[prev in list] [next in list] [prev in thread] [next in thread]