select group by hour of a date string

Results 1 to 2 of 2

Thread: select group by hour of a date string

  1. #1
    J. M. Harper Guest

    Default select group by hour of a date string

    if you don&#039;t mind, I have another question for you<BR><BR>tblJohnsGrades<BR>[grade, date]<BR>[51, 08/08/2001 10:53:00 PM]<BR>[84, 08/08/2001 11:53:00 PM]<BR>[99, 08/08/2001 1:53:00 AM]<BR>[18, 08/08/2001 10:05:00 PM]<BR>[78, 08/08/2001 10:54:00 PM]<BR><BR>Now what I want to do is pull the hours of the date one-by-one to see how many grades were done in that hour....<BR>for example if i wanted to create a chart to see in what hour of the day john&#039;s teacher does most of her grading, what code would I use?<BR><BR>Thanks<BR><BR>J. M. Harper

  2. #2
    Join Date
    Dec 1969

    Default CROSSPOST


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts