Solved it SELECT date_format(date_sub(curdate(), interval 0 month), '%Y-%m-01') AS a, date_sub(date_format(curdate(), '%Y-%m-'+LAST_DAY(CURRENT_DATE)), interval 0 day) AS b
Thanks mmfarhan wrote: > > 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#a13991790 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]
