Friday, June 23, 2017

Convert GETDATE() to YYYYMMDD

How to convert getdate() to YYYYMMDD:

SELECT CONVERT(VARCHAR(35),@date,112)