Answer by ThomasRushton ·
If your "snap_d" column is coming in as a date field, then the
select convert(varchar(8), snap_d, 112)
proposed by Scot should be fine.
If, on the other hand, it's coming in as a string (char / varchar) field, then you'll need to do a bit of string slicing and dicing:
select RIGHT(snap_d,4) + '' + SUBSTRING(snap_d,4,2) + '' + LEFT(snap_s,2)
Answer by dziekan_tek ·