title: How to add 1 day from a user defined date in SQL?
body: <p>What I understood in SQL is if you add 1 day from today's date, you can use </p>
  
  <pre><code>SELECT @date = CONVERT(VARCHAR(8), DATEADD(DAY, 1, GETDATE()), 112) 
  </code></pre>
  
  <p>but my issue is, I am not getting today's date. I have a user defined field for date which I was the one who set this date.</p>
  
  <p>Example: my column is name is "Return Booked", how shall I add 1 day to every return booked I have set?</p>
  
  <p><a href="https://i.stack.imgur.com/X8bdQ.jpg" rel="nofollow noreferrer">See attached: SQL Server result</a></p>
  
  <p>Also, if I try to use CONVERT (DATEADD, *****) I have an error below:</p>
  
  <p>How to deal with the error: Conversion failed when converting date and/or time from character string.</p>
  
  <p>My current SELECT statement is</p>
  
  <pre><code>SELECT dbo.AdditionalDetailInfo.UserDefined6 AS ReturnBooked
  </code></pre>
  
  <p>Note that the data type of UserDefined6 is nvarchar. :(</p>
  
  <p>Thank you!</p>