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

Popular posts from this blog

toolbar - How to add link to user registration inside toobar in admin joomla 3 custom component -

linux - disk space limitation when creating war file -