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%27s-start-day-and-end-day-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/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
