This is an oracle to sql server migration issue
I have a date string in format YYYYMMDDHHMISS and I want to convert it to a sql server date
where HH is 24 hour clock
In Oracle I can use TO_DATE easily, but how do I do this in sql server.
I have tried using CONVERT but I keep getting conversion errors