• Here you go

    declare @test-2 varchar(20)

    set @test-2 ='30/04/2015 23:59:59'

    select CONVERT(datetime, @test-2,103)

    James Phillips
    Sr. Consultant
    Pragmatic Works