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 CFinNC 2009 (Raleigh, North Carolina) with: Andy Matthews

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 »