Home Forums SQL Server 7,2000 T-SQL Convert String to Date RE: Convert String to Date

  • October 17, 2005 at 4:52 am

    #597565

    SELECT SUBSTRING('20050910',7,2)+'/'+SUBSTRING('20050910',5,2)+'/'+SUBSTRING('20050910',1,4)

    /**A strong positive mental attitude will create more miracles than any wonder drug**/