Adding a month to a date in T SQL

Question

How can I add one month to a date that I am checking under the where clause   e g    select   from Reference where reference dt   1 month

User · Answer

Look at DATEADD  SELECT DATEADD mm  1  OrderDate AS TimeFrame   Here s the MSDN  In your case     WHERE reference dt   DATEADD MM 1  myColDate

User · Answer

select   from Reference where reference dt   DateAdd month 1 another date reference

User · Answer

select   from Reference where reference dt   DATEADD mm  1  reference dt

User · Answer

DATEADD is the way to go with this  See the W3Schools tutorial  http   www w3schools com sql func dateadd asp

User · Answer

DateAdd m 1 reference dt    will add a month to the column value

User · Answer

Use DATEADD   DATEADD month  1  reference dt

[sql] Adding a month to a date in T SQL