MySQL search between dates -

-

i have field in table holds registration date in following format

26 august 2013, 5:48:17 am

which best way search between dates in format?

just use between

select    *   table1   date between curdate()    , curdate() - interval 1 day

pay attention, borders included. works on timestamps.


Comments

Post a Comment

Popular posts from this blog

c++ - Linked List error when inserting for the last time -

-
so have part of code here this loop 5 times (max = 5) insert word link list. for ( int = 0 ; < max ; i++ ) { string alphabet = g->returnalphabets(); l[i]->addwords(alphabet[i]); } and have insert word part here string line; fstream myfile ("words.txt"); while (!myfile.eof()) { getline(myfile,line); if ( alphabet == line[0] ) { listnode *newnode = new listnode; if ( head == null ) { newnode->item = alphabet; newnode->next = null; head = newnode; } else { newnode->item = line; prev = cur; prev->next = newnode; } cur = newnode; } } myfile.close(); my problem gives me error on last loop. meaning on max = 4, insert node. rest of loop fine. when decrease max 4 meaning loop 4 times, program error-free when program loops 5 times gives error. anyone can poin...
Read more

c++ - Issues with OpenGL referencing when compiling in Ubuntu terminal -

-
i working on compiling directory of c++ files , headers. thought installed opengl, glut , glew keep getting referencing errors when running it. here doing , errors compiler sending me: user@linux-machine:~/documents/hw$ make g++ -g framework.o poly_line.o shader_program.o circle.o controller.o main.o scene.o view.o -lglew -lglut -lglu -o hw framework.cpp:84: error: undefined reference 'glgeterror' check_gl.h:30: error: undefined reference 'glgeterror' check_gl.h:43: error: undefined reference 'glgeterror' poly_line.cpp:23: error: undefined reference 'glgenbuffers' poly_line.cpp:28: error: undefined reference 'glbindbuffer' poly_line.cpp:29: error: undefined reference 'glbufferdata' poly_line.cpp:54: error: undefined reference 'glenable' poly_line.cpp:55: error: undefined reference 'glenable' poly_line.cpp:56: error: undefined reference 'glblendfunc' poly_line.cpp:57: error: undefined reference 'glhint...
Read more

Using Angularjs $http in browser console -

-
i've testing angularjs services in browser console during development quick verification. way inject service console describe in this question or var $inj = angular.injector(['myapp']); var serv = $inj.get('myservice'); serv.dosomething(); that working angularjs 1.0.7. however, after upgrading 1.1.5, doesn't work anymore services uses $http service, no xhr sent. i've tested injecting $http directly, doesn't work. angularjs changelog seems have no record on issue. may know what's problem here? update: it seems angularjs 1.0.7 uncompressed version doesn't work well. tested working version angularjs 1.0.7 minified. it works uncompressed also. $http = angular.element(document.body).injector().get('$http'); then $http.get(...) // or post or whatever
Read more