Home Forums SQL Server 2016 SQL Server 2016 - Development and T-SQL Update the first and last 2 charactors with year and month RE: Update the first and last 2 charactors with year and month

  • February 14, 2018 at 9:27 am

    #1979765

    I have tried with getdate please change it to the date you need and I have convereted into a string..
    UPDATE  [EC_StoreAttributes]

    SET Left(AttributeValue, 2) =  SELECT RIGHT(CONVERT(VARCHAR(10),GETDATE(),101),2)

    ,    Right(AttributeValue, 2)       =   SELECT LEFT(CONVERT(VARCHAR(10),GETDATE(),101),2)

    WHERE
               AttributeType = 'ECSRCCODE' and StoreRecordId = '1'

    Hope this should work!!
    Happy coding