Tuesday, June 5, 2007

MySql Total Day of Month

SQL Statement below is for MySql Database to get the total day of month.
SELECT DAY(LAST_DAY(now()))

Example of SQL Statement to get the total day of month.
SELECT DAY(LAST_DAY('2007-06-05 22:40:51'))
Return Value = 30

I tested MySql Server 5.0, it is work.