Hello,
Right here one for you. I've just been give a mysql DB to generate some stats from it. It has a varchar with a date line in it I think it's a standard format. eg.
Mon Jul 9 09:28:28 2001
Mon Jul 9 09:37:57 2001
and i want to include a bit that say x entries in the last 24 hours
and x entries in the last 7 days
I don't know where to start
any ideas?
Right here one for you. I've just been give a mysql DB to generate some stats from it. It has a varchar with a date line in it I think it's a standard format. eg.
Mon Jul 9 09:28:28 2001
Mon Jul 9 09:37:57 2001
and i want to include a bit that say x entries in the last 24 hours
and x entries in the last 7 days
I don't know where to start
any ideas?