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

  • October 17, 2005 at 4:46 am

    #597564

    SELECT convert(datetime,'20050910') as myDate

    select convert(varchar(20),convert(datetime,'20050910'),103) as myVarCharDate

    Should do it.