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 |
|
yakoo
Constraint Violating Yak Guru
312 Posts |
 Posted - 2001-10-18 : 16:15:54
|
| Im trying to insert a date value into the database without using milliseconds. Does anyone know how to do this? I have tried using CONVERT(DATETIME, getDate(), 120) but the milliseconds are still be entered.exampleI want to insert10/18/2001 3:03:28 PM into the DB as 2001-10-18 15:03:28.000but it is being entered with the milliseconds as 2001-10-18 15:03:28.553please help. |
|
|
|
|
|
insert getDate() without milliseconds