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