Good evening, Gurus,
I need a datetime column to be presented in the 'YYYYMMDD' format. I've tried all kinds of CONVERT and CAST statements and the results in my target table look like this... '20171e+007'. This should be 20171031. The latest and greatest code =
convert(varchar(10),column_name,112)). This works fine in a basic SQL script but when loading the value to my table I'm getting the
'20171e+007' value. The target column is varchar(80). I've tried DATEPART and just about everything else I can google. Recommendations are very much appreciated!