Ben Nadel
On User Experience (UX) Design, JavaScript, ColdFusion, Node.js, Life, and Love.
I am the chief technical officer at InVision App, Inc - a prototyping and collaboration platform for designers, built by designers. I also rock out in JavaScript and ColdFusion 24x7.
Meanwhile on Twitter
Loading latest tweet...
Ben Nadel at cf.Objective() 2010 (Minneapolis, MN) with: Doug Hughes and Ezra Parker and Dan Wilson and John Mason and Jason Dean and Luis Majano and Mark Mandel and Brian Kotek and Wil Genovese and Rob Brooks-Bilson and Andy Matthews and Simeon Bateman and Ray Camden and Chris Rockett and Joe Bernard and Dan Skaggs and Byron Raines and Barney Boisvert and Simon Free and Steve 'Cutter' Blades and Seth Bienek and Katie Bienek

R A Valencourt

Member since Dec 11, 2008

Recent Blog Comments By R A Valencourt

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

    Posted on Jul 6, 2010 at 11:05 AM

    @Geoff, On Apr 15, 2008 I wrote in part: >> It just makes a blanket a priori determination that if you use the cast/convert operation on a date / float, that the formula will not be deterministic... You wrote: >> Checked this out and Convert is determistic provided you use 100+ style... read more »

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

    Posted on May 13, 2010 at 10:37 AM

    Hmm, I just noticed the "Comment Etiquette" notice, not to post "large chunks of code".... read more »

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

    Posted on May 13, 2010 at 10:35 AM

    Hello Kerr, That is odd that you post of May 4 doesn't appear, either on this page, on in the collection of all of your posts... I did receive an email of your post, and it was very helpful. If you need it, I could send it to you. Perhaps Ben can figure out why it disappears. Regards, RenĂ©... read more »

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

    Posted on Aug 21, 2009 at 1:44 PM

    @Mat, >> A principle I try to adhere to is that the SQL Server code should not be concerned by display issues. By moving that to a different layer you reduce how tightly coupled the code is, a much more flexible situation. This is a crucial issue that too often is still ignored.... read more »

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

    Posted on Aug 20, 2009 at 9:09 AM

    @Mat, >> ...DATEDIFF... is also implementation independant. And it's SARGable. It doesn't bust the optimiser's ability to utilize indexes. From both performance and engineering perspectives it's the way to do when dealing with DATETIMEs. >> ...who proposes string manipulation to solv... read more »

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

    Posted on Aug 20, 2009 at 8:50 AM

    @Ben, The post of September 21, 2007 at Getting Only The Date Part Of A Date/Time Stamp in SQL Server (Revisited) (" http://www.bennadel.com/blog/963-Getting-Only-The-Date-Part-Of-A-Date-Time-Stamp-in-SQL-Server-Revisited-.htm "), states findings that the DATEADD/DATEDIFF method was approximatel... read more »

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

    Posted on Sep 11, 2008 at 3:38 PM

    >> I just used select convert( varchar(10), getdate(), 101) >> Isn't it that easy? maybe I missed something That works fine for display, but if you want to store the data and be able to do data operations on it, I think you need to convert it back to datetime... RenĂ©... read more »

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

    Posted on Apr 15, 2008 at 9:33 AM

    Last September Joseph wrote: >> Determinism is basically a property that says a function will always return the exact same value for a given set of parameters. It is essential that this be true in order to build an index on a calculated column. UDFs that involve rounding or data conversion ... read more »

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

    Posted on Mar 24, 2008 at 5:03 PM

    Oops, I just noticed a typo in my post from February 28... I posted cast(floor(cast(MyDateField as float) as datetime) when I meant cast(floor(cast(MyDateField as float)) as datetime)... read more »

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

    Posted on Feb 28, 2008 at 3:42 PM

    Joseph, You wrote last fall: >> I know it is very particular though, and using things like convert and floating points and stuff like that don't work. ... I would be absolutely thrilled if I could find a formula that is easier than the one I've been using but is also deterministic. cast(f... read more »