"Mike Blezien" <[EMAIL PROTECTED]> wrote on 04/04/2006 02:47:50 PM:
> Hello, > > is there a MySQL function to determine the total days of any given > month, IE if > current month is April, is there a function or query to find the > total days of > the month? > > TIA, > Mike(mickalo)Blezien > =============================== > Thunder Rain Internet Publishing > Providing Internet Solution that Work > =============================== > Well, the first place I would have looked is in the manual... http://dev.mysql.com/doc/refman/4.1/en/index.html Having skimmed through it at least once (something I recommend that everyone does), I know there is a section describing all of the functions that work with date and time values... http://dev.mysql.com/doc/refman/4.1/en/date-and-time-functions.html where I found a function to return exactly what you were looking for... http://dev.mysql.com/doc/refman/4.1/en/date-and-time-functions.html#id2691432 Respectfully, Shawn Green Database Administrator Unimin Corporation - Spruce Pine