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 |
|
Asdzxc1986
Starting Member
14 Posts |
 Posted - 2009-12-19 : 14:00:13
|
| Hi.I need to change date, without changing the time.Example: 29.12.1899 22:34:00 need to change on30.12.1899 22:34:00update d_route set time = ? where oper_id=0 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
Asdzxc1986
Starting Member
14 Posts |
Posted - 2009-12-19 : 14:32:14
|
| I have a table with hungred rows of data. All oh them are different. How can I change column time? I need change only date part, with saving time part? |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
Asdzxc1986
Starting Member
14 Posts |
Posted - 2009-12-19 : 15:01:06
|
| I have column TIME. In that column I have different values like: 29.12.1899 22:34:0029.12.1899 21:34:0029.12.1899 20:34:0029.12.1899 19:34:00I need to change that values on30.12.1899 22:34:0030.12.1899 21:34:0030.12.1899 20:34:0030.12.1899 19:34:00I dont understand how to take time part from '29.12.1899 19:34:00' and put it into time place?update d_routeset time = DATEADD('30.12.1899', 1, ?)where oper_id=0 |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
datetime problem