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


Member since Dec 11, 2008

Recent Blog Comments By Andrew

  • Getting Only the Date Part of a Date/Time Stamp in SQL Server

    Posted on Apr 2, 2007 at 2:20 PM

    Garth had it right, at least with SQL Server. You don't need a custom function to do what's already built in. If you need to use it in a comparison you can easily do something like WHERE CONVERT(nvarchar(20), MyDateColumn, 101) BETWEEN @DateFrom AND @DateTo I always forget the syntax though and ... read more »