CodingForums.com - View Single Post - count inserted records for a specific day of the week

mbarandao · 02-10-2013, 04:05 PM

Hello all:

I would like to query my mysql table for a total number of records inserted during a specified day of the week within a specified time period.

More clearly: count number records inserted on Tuesdays during the time period of 2013-01-31 - 2013-02-03. The first day of the week being Monday.

My date field in mysql is formated as 0000-00-00 00:00:00

Any thoughts on this is appreciated

Best,
Mossa

02-10-2013, 04:05 PM	PM User \| #1
mbarandao Regular Coder Join Date: Nov 2010 Location: Washington DC Posts: 311 Thanks: 19 Thanked 1 Time in 1 Post	count inserted records for a specific day of the week Hello all: I would like to query my mysql table for a total number of records inserted during a specified day of the week within a specified time period. More clearly: count number records inserted on Tuesdays during the time period of 2013-01-31 - 2013-02-03. The first day of the week being Monday. My date field in mysql is formated as 0000-00-00 00:00:00 Any thoughts on this is appreciated Best, Mossa