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
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
Because i am writing a report using iReport (which is a JasperReport's
Designer) and I thaught Query is an easy way to get these values.
mgainty wrote:
>
> 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
> mys
