query by time

Collapse
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • esadler
    New Member
    • Jul 2007
    • 2
    #1

    query by time

    I am trying to query a db by date and time ie I want records from 9/2/2007 to 9/22/2007 (selectable @startdate and @enddate) also i want to be able to sort by time ie shift (1st 7:00am to 3:00pm 2nd 3:00 pm to 11:00 pm 3rd 11:00pm to 7:00am) i can query for the date but not sure how to by time. my db data is coming in 9/13/2007 10:35:18 AM

    Thanks

    Ed
    Tags: None
    • ck9663
      Recognized Expert Specialist
      • Jun 2007
      • 2878
      #2
      Originally posted by esadler
      I am trying to query a db by date and time ie I want records from 9/2/2007 to 9/22/2007 (selectable @startdate and @enddate) also i want to be able to sort by time ie shift (1st 7:00am to 3:00pm 2nd 3:00 pm to 11:00 pm 3rd 11:00pm to 7:00am) i can query for the date but not sure how to by time. my db data is coming in 9/13/2007 10:35:18 AM

      Thanks

      Ed

      consider the BETWEEN operator (is it an operator or clause or pharse :D )...

      search the online help

        Comment

        Previous template Next
        Working...