this will get you the start day
mysql> select DATE_FORMAT(CONCAT(SUBSTR(NOW(),1,8),'01'),'%a');

this will get you the end day
mysql> select DATE_FORMAT(LAST_DAY(NOW()),'%a');

Is there a reason why you dont want to use a programming language for this
task?
M--
----- Original Message -----
Wrom: WLSZLKBRNVWWCUFPEGAUTFJMVRESKPNKMBIP
To: <mysql@lists.mysql.com>
Sent: Wednesday, November 28, 2007 7:35 AM
Subject: Current month's start day and end day


>
> Hi,
> How can i get current month's start day and end day using mysql query.
>
> Thanks
> --
> View this message in context:
http://www.nabble.com/Current-month%...tf4888220.html
#a13991390
> Sent from the MySQL - General mailing list archive at Nabble.com.
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql?unsub=mgainty@hotmail.com
>
>