Afan, you'll need to have a date and time column in the database storing a "created at" value, that is set on INSERT and then not changed.
Assuming you have such a column - let's call it "created_at" - you can run queries like this: /* to get count of records created on Mondays */ SELECT COUNT(*) FROM table t WHERE DAYOFWEEK(t.created_at) = 2; /* to get count created on a given date between 8 AM and 4 PM */ SELECT COUNT(*) FROM table t WHERE t.created_at >= "2007-11-20 8:00" AND t.created_at <= "2007-11-20 16:00"; MySQL's docs on date and time functions are here: http://dev.mysql.com/doc/refman/5.0/en/date-and-time-functions.html HTH, Dan On Nov 20, 2007 12:16 PM, Afan Pasalic <[EMAIL PROTECTED]> wrote: > Hi, > I have to build a report - when (date and/or time) the records are > inserted. E.g., number of records inserted on Monday - doesn't matter > what month. > Or, number of records inserted on specific date between 8am and 4pm. > > Thanks for any help. > > -afan > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > >
