Sql Between Datetime. Sql where between clause what can i do with the where between clause. The following example retrieves rows in which datetime values are between 20011212 and 20020105 inclusive.
Where between returns values that fall within a given range. Between does include the endpoints of the range. The query retrieves the expected rows because the date values in the query and the datetime values stored in the ratechangedate column have been specified without the time part of the date.
This is because the datetime data type contains both date and time.
The between operator selects values within a given range. On 2002 01 05 would not be returned by this query because it falls outside the range. The query retrieves the expected rows because the date values in the query and the datetime values stored in the ratechangedate column have been specified without the time part of the date. The sql between operator.
