R A Valencourt

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 »