Hey, am sure there someone here that can help me with this. Its a simple sql query but am not sure how to do it. I just want to display how many files were uploaded in a week,month,year.
There is a Date column in bx_files_main. However, its not in any format i know off. usually the format would be 12-05-2012. but instead it is in 1341509607.
Just want to display the total downloads of products in the store per week, month year. Something lik et
hat
Please help. Would be really appricated.
