user Posted December 10, 2003 Report Share Posted December 10, 2003 interesē kā varētu atlasīt skaitu tieksim pa dienām... datu bāzē datums ir kā "2003-12-10 10:10:10" vajadzētu lai beigas nomet nost un tad <i>group by date</i>.. kā to izdarīt?? Link to comment Share on other sites More sharing options...
jb4 Posted December 10, 2003 Report Share Posted December 10, 2003 SELECT * FROM table GROUP BY SUBSTRING(fieldname,0,10) Link to comment Share on other sites More sharing options...
Recommended Posts