Date & Time

[UKlee]

Hi all back with another question or two 🙂 PHP Version 4.3.11 used

Is there a way to get a count of every item submited to your database table on a given weekday. This info is stored using the date time format.

I was wondering can I grab a count on how many where submited on a monday and so on .

also is it possible to select say a given time or perhaps x amount submited in the am period or pm period .

I have looked around but date time is my nemisis or is turning out to be my nemisis.

Thank you for taking the time to look

Kind regards

Lee

[jdorsch]

Your best bet is to look into using timespans in an SQL statement. This will let you bypass messing around with dates in php and sql. You should be able to do everything you describe within SQL.