101 reputation
1
bio website alivate.com.au
location Geelong
age 28
visits member for 1 year, 8 months
seen Jan 17 '13 at 0:31

Software developer, working mainly in the .NET environment


Jan
17
comment Why is SQL's BETWEEN inclusive?
Your example focuses on integers, for decimal numbers and other delimited quantities (such as dates), the term between is ambiguous. If I say have you done X between 2012 and 2013, I don't include 2013 (or specifically the day 2013-01-01)
Jan
17
comment Why is SQL's BETWEEN inclusive?
I understand your frustration, (StartDate >= '2010-01-01' and StartDate < '2011-01-01'), works beautifully, to use Between the equivelent would be (StartDate between '2010-01-01' and '2010-12-31 23:59:59'), both bulky and one needs to know how many days are in Dec.
Jan
17
awarded  Autobiographer