I have a column
createdate char(26)
2004-01-30-21.29.12.893374
DATETIME
Convert(DATETIME, createdate,120)
The conversion of a varchar data type to a datetime data type resulted in an out-of-range value.
createdate char(26)
char
datetime
Declare @String varchar(50) = '2004-01-30-21.29.12.893374'
Select cast(Left(Stuff(Replace(Stuff(@String,11,1,' '),'.',':'),20,1,'.'),23) as datetime)
Returns
2004-01-30 21:29:12.893
OR for DateTime2
Declare @String varchar(50) = '2004-01-30-21.29.12.893374'
Select cast(Stuff(Replace(Stuff(@String,11,1,' '),'.',':'),20,1,'.') as datetime2)
Returns
2004-01-30 21:29:12.8933740