Home Forums SQL Server 2014 Administration - SQL Server 2014 Trying to convert varchar to datetime RE: Trying to convert varchar to datetime

  • July 26, 2013 at 8:41 pm

    #1636384

    dwain.c (7/24/2013)[hrGee whiz! And here I was thinking my STUFF solution was pretty clever.

    Nice one Jeff!

    Thanks, Dwain. Indeed the STUFF solution is clever. I went for the super simple based on a little arcane knowledge that you don't have to select the perfect length string if you want to read to the end of the string. Instead of 5,2 for the substring start and length, I could have just as easily used 5,8000 and it would have produced the same results.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)