From: mmfarhan (farhancybercomcity.com)
Date: Wed Nov 28 2007 - 11:53:18 CST

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

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
> 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: <mysqllists.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/mysql?unsub=mgaintyhotmail.com
>>
>>
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql?unsub=listsnabble.com
>
>
>

--
View this message in context: http://www.nabble.com/Current-month%27s-start-day-and-end-day-tf4888220.html#a13996206
Sent from the MySQL - General mailing list archive at Nabble.com.

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]