Does the BETWEEN operator capture the end points. For exmaple if I want to captue all records within date range of 1/1/2005 and 1/31/2005, including the first and last day, will the BETWEEN operator capture all those records or just the ones from 1/2/2005 to 1/30/2005? Thanks.
However, beware with dates that there is also a time component that defaults to 00:00:00. So with your example, a date of 01/31/2005 with a time component of (e.g.) 14:30:00 will fall outside the date range (which ends at 01/31/2005 00:00:00).