Home Forums SQL Server 2008 T-SQL (SS2K8) Date Parse Help RE: Date Parse Help

  • August 3, 2013 at 5:59 pm

    #1638462

    rocky_498 (8/2/2013)

    Hi Guys,

    Here is my Date Column, sample data below

    20130801173009

    20130801173009

    20130801173009

    20130801173009

    20130801173009

    20130801173009

    Is someone can help me to parse in Year,Month, Day and rest are time?

    Thanks in advance.

    Before we run off with the good solution given so far, let's make sure that cuff's match collar for datatypes. What is the datatype of your datecolumn? If it's not CHAR or VARCHAR, it might be wise for us to try something just a little different,

    --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)