title: How do I convert a value after using DATEADD with it
body: <p>I have a little query that strips the date from the datetime field but when I try to convert it from GMT to CST it readds the date.  Is there a better way to do this?</p>
  
  <p>Location table:</p>
  
  <pre><code>arrival
  4-6-2018 12:35:43
  
  
  
  
  SELECT arrival
  FROM(
  SELECT CONVERT(VARCHAR(8), arrival))
  FROM locations
  )a
  </code></pre>
  
  <p>This query will give me this result:</p>
  
  <p>12:35:43</p>
  
  <pre><code>SELECT (DATEADD(hour,-5,arrival))
  FROM(
  SELECT CONVERT(VARCHAR(8), arrival))
  FROM locations
  )a
  </code></pre>
  
  <p>4-6-2018 12:35:43</p>
  
  <p>This query will give readd the date.  How can I remove the date and then do the dateadd function without it readding the date</p>