Post reply

Date Format

  • September 17, 2008 at 3:08 am

    #124722

    in my source flie one coulumn is date column like[17092008], i need to load destination in to [17-09-2008], can any body help on this.

    Regards,

    ss

  • September 17, 2008 at 8:49 pm

    #873359

    Dunnor if it works in Integration Services, but I Use STUFF to quickly add a couple of dashes.

    --===== Setup a simple test.

    -- This is NOT part of the solution

    DECLARE @FlatDate CHAR(8)

    SET @FlatDate = '17092008'

    --===== Demo how STUFF works here

    SELECT STUFF(STUFF(@FlatDate,5,0,'-'),3,0,'-')

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

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply