Post reply

Select ALL records where the time in DateTimeField = 9AM

  • November 11, 2014 at 2:07 pm

    #99986

    I have a table with that stores hourly data. The customer wants a monthly report, but only wants the records for 9AM to be displayed on the report. So I need to figure out how to select DateTimeField, Volume FROM tblHourlyHistory WHERE DateTimeField = 9AM.

    Any ideas?

  • November 11, 2014 at 2:27 pm

    #1757799

    Something along these lines:

    SELECT SalesOrderID

    FROM Sales.SalesOrderHeader

    WHERE DATEPART(hh,OrderDate) BETWEEN 9 AND 12;

  • November 12, 2014 at 5:51 am

    #1757934

    Thanks!

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply