https://social.msdn.microsoft.com/Forums/sqlserver/en-US/b5e8cca7-8fcc-4370-b465-bf3e536dd320/convert-a-datetime-to-yyyymmdd?forum=transactsql
Anonymous
You can always add complexity.
