Question: how to find last day 0f any given month in mysql?
how to find last day of any given month in mysql?
Here is required code:
DECLARE @dtDate DATETIME SET @dtDate = '8/18/2007' SELECT DATEADD(s,-1,DATEADD(mm, DATEDIFF(m,0,@dtDate)+1,0))
hi, SELECT LASTDAY('2003-02-05')FROM tablename