Comparing Time Stamps

• Mark Harley

  SSCrazy

  Points: 2259

  More actions

  November 9, 2007 at 11:31 am

  #181034

  The application my db is tied to allows the user to select times for filtering the data (for example, task begins between 04:30 and 11:00, and task ends between 15:00 and 16:00). The task data is stored in the database as a datetime field, and I'm not sure how to compare the time portion of that field with the user-entered times. Any suggestions?

• Mark Harley

  SSCrazy

  Points: 2259

  More actions

  November 9, 2007 at 11:52 am

  #749955

  I got this to work using a simple CONVERT statement to retrieve the time portion of the datetime field.

  CONVERT(VARCHAR(8), timefield, 108)

  This seems to suit my purpose quite well, although there may be a better way.