title: How to check if a given date is in yyyymmdd format sql server
body: <p>I spent quit a long time and could not figure out how can i check if a given date is in YYYYMMDD format. Can anyone suggest me a simple way that this can be achieved in sql </p>
  
  <p>Thanks. </p>