todays posts added count

by Prakash 2013-08-03 16:49:11

To check todays posts added count use the following query.


select count(*) from posts where day(dat) = day(current_date) and month(dat) = month(current_date) and year(dat) = year(current_date)


In the above query the 'dat' field specifies the date post added.

Tagged in:

405
like
0
dislike
0
mail
flag

You must LOGIN to add comments