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]

Reply via email to