Home Forums SQL Server 2014 Development - SQL Server 2014 Datetime conversion RE: Datetime conversion
jphillips 46546
SSC-Addicted
Points: 439
More actions
April 8, 2015 at 7:46 am
#1789538
Here you go
declare @test-2 varchar(20)
set @test-2 ='30/04/2015 23:59:59'
select CONVERT(datetime, @test-2,103)
James PhillipsSr. ConsultantPragmatic Works