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 |
|
christina_rules
Starting Member
23 Posts |
 Posted - 2007-07-04 : 02:17:07
|
| i've used this to add the day but my problem is that the result is not really accurate...dateadd(dd, 3, convert(datetime, convert(int, getdate())))..for example, today is 4th of july..after addition, it becomes 8th of july when it's suppose to be 7th..why? |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
|
|
|
|
|
getdate() problem