RE: Days in a month

2003-03-01 Thread Don Read
On 02-Mar-2003 Steffan A. Cline wrote: > Is there a function that I missed for calculating the number of days in a > month? > TO_DAYS() mysql> set @b:='2003-02-01'; Query OK, 0 rows affected (0.00 sec) mysql> set @e:='2003-03-01'; Query OK, 0 rows affected (

Re: Days in a month

2003-03-01 Thread Paul DuBois
At 17:13 -0700 3/1/03, Steffan A. Cline wrote: Is there a function that I missed for calculating the number of days in a month? No, but you can calculate it. One way: - Find the first of the month - Add a month - Subtract a day. That gives you the last day of the month. - Extract the day-of-the

Days in a month

2003-03-01 Thread Steffan A. Cline
Is there a function that I missed for calculating the number of days in a month? Steffan MySQL --- T E L 6 0 2 . 5 7 9 . 4 2 3 0 | F A X 6 0 2 . 9 7 1 . 1 6 9 4 Steffan A. Cline [EMAIL PROTECTED] Phoenix