title: Date format on GridView, ASP.NET
body: <p>I want to return the date part only from my database when I execute a SELECT statement. 
  (in the statement below: Task.ST_Date)</p>
  
  <pre><code>SELECT Task.Details, Task.Pr_ID, EmTask.T_ID, Task.Ref_ID, Task.ST_Date
  FROM Task
  INNER JOIN EmTask ON Task.Ref_ID = EmTask.T_ID
  WHERE EmTask.Em_ID = 214432
      AND Task.STATUS = 'WAITING'
      AND Task.ST_Date BETWEEN CONVERT(VARCHAR(10), GETDATE(), 120)
          AND CONVERT(VARCHAR(10), GETDATE() + 6, 120)
  </code></pre>
  
  <p>This statement works, but when I view it in a gridview, this format shows: <strong>2/3/2017 12:00:00 AM</strong>
  <a href="https://i.stack.imgur.com/14aA4.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/14aA4.jpg" alt="enter image description here"></a></p>
  
  <p>Is there any way that I can modify the format into 'yyyy-MM-dd'?</p>
  
  <p>*within the database (MSSQL): date datatype , yyyy-MM-dd format 
  <a href="https://i.stack.imgur.com/d7ObD.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/d7ObD.jpg" alt="enter image description here"></a></p>