Skip to main content
Ben Nadel
On User Experience (UX) Design, JavaScript, ColdFusion, Node.js, Life, and Love.

Markus Diersbock

Member since Dec 11, 2008

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 »