Tuesday, June 5, 2007

MySql Total Day of Month

SQL Statement below is for MySql Database to get the total day of month.

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.


Anonymous said...

WoW nice blog buddy!Actually WoW is my favorite appreciation keyword. I also like to play. Wow Gold. I was looking for info regarding that and saw your website. Its nice and very interesting.

Anonymous said...

i've tested the query in some cases, including total day of february in a leap year.

it works!


Mind said...

wow news

Good post

Mind said...

Good blog

Nice Post

Mind said...

wow gold kaufen

Interesting post