im trying to convert my column of data type datetime. this is an example of what the data looks like:
2007-01-24 10:01:29.710
i want to format it as so
200701241001
ive tried this so far i think im sort of on the right track
RIGHT('000000000000' + CONVERT(varchar(20), CONVERT(int, sr.ResponseDate)),12) AS FinalDate
but its not outputting exactly what i want
thanks
andreas