There is a field in a table with type and length as varchar(255). It stores a value as follows 'Patch_Test_9_10_201012;00;00AM'. I need to extract 9_10_201012;00;00AM and format it as 9/10/2010 12:00:00 AM. I tried CONVERT and CONVERT+CAST
it won't work.
Is there a way to do it? Please, any ideas , inputs are wellcome
View Complete Post