-1

How would I add an additional day to this?

,Cast([real_dd] as Date) Delivery_Date
Dale K
  • 25,246
  • 15
  • 42
  • 71
Drew M
  • 13
  • 5
  • SELECT DATEADD(DD,1,@Date) – Mikael Jul 30 '20 at 19:38
  • Does this answer your question? [How to add days to the current date in sql server?](https://stackoverflow.com/questions/23013277/how-to-add-days-to-the-current-date-in-sql-server) – Dale K Jul 30 '20 at 20:23

1 Answers1

1

You would use dateadd():

select dateadd(day, 1, cast(read_dd as date)) as delivery_date
Gordon Linoff
  • 1,242,037
  • 58
  • 646
  • 786