« Return to Thread: Current month's start day and end day

Re: Current month's start day and end day

by mmfarhan :: Rate this Message:

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

« Return to Thread: Current month's start day and end day