sql - how to query mysql on the current week? -


this query current day: 

select count(*) blog_posts poststatus = "pending" , date(date_accepted) = curdate()

now how if want query week? in advance..

use yearweek() function

where yearweek(date_accepted) = yearweek(now())

don't use week() because match weeks different years.


Comments

Post a Comment

Popular posts from this blog

jpa - Passing entitymanager from reflection method -

we using struts2, ejb jpa. @persistencecontext private entitymanager entitymanager; // here getting entitymanager reflection method m = c.getdeclaredmethod(methodname, params); //here params accept class<?> now want pass entitymanager using reflection. how pass entitymanager in getdeclaredmethod ? billy, reply. now fixed issue using transactionscopedentitymanager. we using struts2 + ejb + jpa 1.0 (cmt). have many action classes , form values persist in db. created ejb every 1 action. planing 1 ejb action classes. go reflection. using getdeclaredmethod, can pass method name , params. here params accept classes. need pass our form object , entitymanager. used entitymanager type, changed transactionscopedentitymanager.
Read more

frame rate - JAVA simple fps animation(how can i work with?) -

can me, how can calculate , show fps in animation? want show simple rect (for example). if have code: private final fps = 30; private final size = 10; private int x = 10; private int y = 0; private string myfps; private void start(){ while(true){ moverect(); paint(); } } private void paint(){ g2.drawrect(x, y, size, size); g2.drawstring(myfps, 10, 10); } private void moverect(){ x++; } here copypaste of old simple java graphics+bufferstrategy gameloop test app. animation loop draws few moving rectangles , fps counter. java -cp ./lib/test.jar gameloop2 "fullscreen=false" "fps=60" "vsync=true" //http://www.javagaming.org/index.php/topic,19971.0.html //http://fivedots.coe.psu.ac.th/~ad/jg/ch1/ch1.pdf import java.util.*; import java.awt.color; import java.awt.frame; import java.awt.graphics; import java.awt.graphicsconfiguration; import java.awt.graphicsdevice; import java.awt.graphicsenvironmen...
Read more