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.

5 comments:

Ashley 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.

resensibuku said...

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

it works!

thanx,

Mind said...

wow news

Good post

Mind said...

Good blog


Nice Post

Mind said...

wow gold kaufen

Interesting post