Home Forums SQL Server 2005 T-SQL (SS2K5) Convert MMDDYY to YYYYMMDD RE: Convert MMDDYY to YYYYMMDD

  • September 18, 2009 at 7:42 am

    #1055597

    simply reverse the process...

    declare @yyyymmdd char(8)

    set @yyyymmdd = '20070918'

    select replace(convert(varchar,convert(datetime,@yyyymmdd,10), 10),'-','')

    gives

    091807

    Kev