title: How to extract date from a DateNow() in YYYYMMDD format in SQL Server
body: <p>Got a specific requirement that we should extract only date and in YYYYMMDD format from GETDATE() in Sql-Server 2005.</p>
  
  <p>How can I accomplish this.</p>
  
  <p>Thanks</p>