java - Get list of quarter from startDate and enddate -
i'm working struts2 , jpa , mysql in webapp . in table have 2 column startdate , enddate , want quarters between startdate , enddate . example have 2 dates below :
startdate 2013-01-23 enddate 2015-11-29 i want list :
jan 2013 apr 2013 jul 2013 oct 2013 jan 2014 apr 2014 jul 2014 ...... ...... ...... jul 2015 oct 2015 my goal quarters in select list.
edite 1 : to start i'm working on query in phpmyadmin :
select listt ( select cast(select `startdate` tablea date) datevalue union select date_add(q,1,datevalue) listt date_add(q,1,datevalue) < cast(select `enddate` tablea date) ) select convert(varchar(3), datename(month,datevalue))+ ' ' +convert(varchar(4),datepart(yyyy,datevalue)) listt option (maxrecursion 0) and put query in dao class :
public list<date> listdate() { list<date> pay = null; try { pay = session.createquery("my query").list(); } catch (exception e) { e.printstacktrace(); } return pay; }
Comments
Post a Comment