Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
nt4vn
Yak Posting Veteran
98 Posts |
 Posted - 2008-11-14 : 13:26:04
|
| Hello, I want to write a statement that indicates a.item_date plus 6 month < b.item_date. I was not sure if the below is the right statement. Please advise. Thanks,dateadd(mm, 6,a.item_date)<b.item_date |
|
|
lionofdezert
Aged Yak Warrior
885 Posts |
Posted - 2008-11-14 : 14:14:08
|
| you r on right way buddy...Don't forget to see Jeff's article on Essential SQL SERVER Datetime functionshttp://weblogs.sqlteam.com/jeffs/archive/2007/01/02/56079.aspx |
 |
|
|
|
|
|
dateadd function