• SELECT YEAR(GETDATE())*10000 + MONTH(GETDATE())*100 + DAY(GETDATE())