Ben Nadel
On User Experience (UX) Design, JavaScript, ColdFusion, Node.js, Life, and Love.
Ben Nadel at Scotch On The Rocks (SOTR) 2011 (Edinburgh) with: Cyril Hanquez and Hugo Sombreireiro and Reto Aeberli and Steven Peeters and Guust Nieuwenhuis and Aurélien Deleusière and Damien Bruyndonckx
Ben Nadel at Scotch On The Rocks (SOTR) 2011 (Edinburgh) with: Cyril Hanquez@Fitzchev ) , Hugo Sombreireiro@hsombreireiro ) , Reto Aeberli@aeberli ) , Steven Peeters@aikisteve ) , Guust Nieuwenhuis@Lagaffe ) , Aurélien Deleusière@adeleusiere ) , and Damien Bruyndonckx ( @damienbkx )

Russell Sneddon

Member since Jan 31, 2010

Recent Blog Comments By Russell Sneddon

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

    Posted on Jul 5, 2010 at 12:08 PM

    Hey Geoff I'm glad you found my posts useful. Perhaps I misinterpreted your sentence "So the simple chararacter conversion using CONVERT may not be the fastest but it can be deterministic and henced used in indexes."? I thought you meant that it was worth using the slower technique because of its... read more »

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

    Posted on Jul 5, 2010 at 11:41 AM

    Geoff As I said in my posts, all 16 techniques that I describe are deterministic. They cover a variety of ways of solving the problem, not just character conversion. Russ... read more »

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

    Posted on Jan 31, 2010 at 2:58 PM

    Actually Brian Young's post directly before mine is technically correct. He suggests using: DATEADD(DAY, DATEDIFF(DAY, 0, @DateTime), 0) instead of using: DATEADD(DAY, 0, DATEDIFF(DAY, 0, @DateTime)) which is a closer representation to what we're trying to achieve. About half the DATEADD exampl... read more »

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

    Posted on Jan 31, 2010 at 12:16 PM

    Thanks very much for all the useful information. The function below shows 12(!) different techniques (including a few inspired by this thread), which I've proved return identical results for a spread of times on every possible date. Just comment out one line at a time to try each technique. It shou... read more »