title: Extracting yyyy/MM/dd formated date from datetime datatype in T-SQL
body: <p>I have my date values in postdate column in articles table in  sql database table. It stores all date as well as time. I would like to get the date part only. i.e from 2010/07/01 12:45:12 i would likfe to get 2010/07/01
  in my view</p>