SELECT Date(mydate),sum(price),username from shop_table where Date(mydate)>'2011-01-07' GROUP BY Date(mydate),username Because the dates include the time, I convert them into 'only date' using Date() ...
MySQL UDF function implemented in C++ for getting the unix timestamp of a DATETIME, TIME, DATE, TIMESTAMP field in miliseconds. Much faster than UNIX_TIMESTAMP builtin function.
Some results have been hidden because they may be inaccessible to you
Show inaccessible results