Take the 2-minute tour ×
Stack Overflow is a question and answer site for professional and enthusiast programmers. It's 100% free, no registration required.

I have 1 date column i'd like to change in a database based on the date in another column. Here are my columns with sample output

dtexpires    dtcreated
1/1/13         1/15/13
1/1/13         1/16/13
1/1/13         2/1/13

I would like to change "dtexpires" to be "dtcreated" PLUS 30 Days.

Table name is "Customers"

share|improve this question
add comment

3 Answers

up vote 3 down vote accepted

You need to use DATEADD:

UPDATE Customers
SET dtExpires = DATEADD(dd,30,dtCreated)

http://msdn.microsoft.com/en-us/library/ms186819.aspx

share|improve this answer
add comment
UPDATE customers
SET dtexpires = dateadd(d,30,dtcreated)
share|improve this answer
add comment

Your sample data look like you storing string as dates. Assuming dtcreated is a date type field

update customers
set dtexpires = dateadd(day,30, dtcreated)
share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.
{"cc_re__cc_re__cc_by_sa_3_0": ["        <li><a href=\"http://area51.stackexchange.com\" title=\"proposing new sites in the Stack Exchange network\">Area 51</a></li>\r\n                        <li><a href=\"http://careers.stackoverflow.com\">Stack Overflow Careers</a></li>\r\n                    \r\n                </ol>\r\n            </td>\r\n    </tr>\r\n</table>\r\n                </div>\r\n            </div>\r\n\r\n            <div id=\"copyright\">\r\n                site design / logo &#169; 2014 stack exchange inc; user contributions licensed under <a href=\"http://creativecommons.org/licenses/by-sa/3.0/\" rel=\"license\">cc by-sa 3.0</a> \r\n                with <a href=\"http://blog.stackoverflow.com/2009/06/attribution-required/\" rel=\"license\">attribution required</a>\r\n            </div>\r\n            <div id=\"svnrev\">\r\n                rev 2014.3.14.1461\r\n            </div>\r\n            \r\n        </div>\r\n    </div>\r\n    <noscript>\r\n        <div id=\"noscript-warning\">Stack Overflow works best with JavaScript enabled<img src=\"http://pixel.quantserve.com/pixel/p-c1rF4kxgLUzNc.gif\" alt=\"\" class=\"dno\"></div>\r\n    </nos"], "copyright__copyright__copyright": ["er\nadd comment\nUPDATE customers\nSET dtexpires = dateadd(d,30,dtcreated)\nshare|improve this answer\nadd comment\n\nYour sample data look like you storing string as dates. Assuming dtcreated is a date type field\n\nupdate customers\nset dtexpires = dateadd(day,30, dtcreated)\nshare|improve this answer\nadd comment\n\nYour Answer\n\n\u00a0\ndiscard\n\nBy posting your answer, you agree to the privacy policy and terms of service.\n\nNot the answer you're looking for? Browse other questions tagged or ask your own question."]}