List:General Discussion« Previous MessageNext Message »
From:mmfarhan Date:November 28 2007 5:53pm
Subject:Re: Current month's start day and end day
View as plain text  
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: <mysql@stripped>
> 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=1
>>
>>
> 
> 
> -- 
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    http://lists.mysql.com/mysql?unsub=1
> 
> 
> 

-- 
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.

Thread
Current month's start day and end daymmfarhan28 Nov
  • Re: Current month's start day and end daymmfarhan28 Nov
  • Re: Current month's start day and end daymgainty28 Nov
    • Re: Current month's start day and end daymmfarhan28 Nov