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: <[email protected]> > 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/[EMAIL PROTECTED] >> >> > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > > -- 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 To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
