Q: Last day of month

[Robert Andersson]

Hi all!

I have been looking through chapter 7.3.11 (date and time functions)
but could not find a function that returns the last day of a
month. Or have I overlooked something?
	   The function that I want could look something like

	   LASTDAYOFMONTH(V) or NUMBEROFDAYSINMONTH(V)
	   Returns the last day of the month of V, where V could be in the
	   format YYMM or YYYYMM.

Is there a simple solution in mySQL to do this or do I have to do it
»externally«?

Yours,
/Robert

-- 
Computational Linguistics
Department of Linguistics
Göteborg University