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 |
|
sonial8
Starting Member
5 Posts |
 Posted - 2009-09-28 : 15:16:20
|
| How would I update a date part day in the table.I want to update all records for an id where date is 2009-07-25:00:00.. to July 30, I want to retain the timestamp hence only want to update the day portion of the date. update tablename set datepart(dd, name of column)??Thanks in advance.Soniasonia |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
sonial8
Starting Member
5 Posts |
Posted - 2009-09-28 : 15:21:37
|
| TKizer you are awesome! thanks much this workedsonia |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
how to update datepart day