Markus Diersbock
Member since Dec 11, 2008
- Profile: /members/668-markus-diersbock.htm
- URL: http://www.swingnote.com
- Comments: 1
Recent Blog Comments By Markus Diersbock
-
SQL Date/Time BETWEEN And Comparison Operators Work With Floats
Posted on Feb 11, 2007 at 12:11 AM
"... the second value is exlusive (excludes 08/05). I just think that is wicked cool." Why is that cool? It breaks BETWEEN. Also if you want to have a range with one day, you'd have to use 39120.0 AND 39120.9. Using INTs rather than FLOATS resolves this, because it ignores time in a DateTime fiel... read more »