pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
number of days in a month
2+ messages / 2 participants
[nested] [flat]

* number of days in a month
@ 2001-05-11 06:19  Cwhisperer <Cwhisperer@vo.lu>
  0 siblings, 1 reply; 2+ messages in thread

From: Cwhisperer @ 2001-05-11 06:19 UTC (permalink / raw)
  To: pgsql-sql

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:Cwhisperer@vo.lu





^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: number of days in a month
@ 2001-05-11 18:15  Kaare Rasmussen <kar@webline.dk>
  parent: Cwhisperer <Cwhisperer@vo.lu>
  0 siblings, 0 replies; 2+ messages in thread

From: Kaare Rasmussen @ 2001-05-11 18:15 UTC (permalink / raw)
  To: Cwhisperer <Cwhisperer@vo.lu>; pgsql-sql

>  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



^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2001-05-11 18:15 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2001-05-11 06:19 number of days in a month Cwhisperer <Cwhisperer@vo.lu>
2001-05-11 18:15 ` Kaare Rasmussen <kar@webline.dk>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox