I have two tables, one is populated by a simple insert statement and the other using a Table-Valued Parameter (due to the quantity of rows) and they both work from within an application.

The dates are passed from a .NET variable so they are both using the same value.

Both are `DATETIME NOT NULL`, however when the TVP enters the datetime it comes through like so:

```
2016-02-24 09:40:26.647

```

However in the `INSERT INTO` on the other table this comes through as:

```
2016-02-24 09:40:26.000

```

I need to join these values with another to link the data together, however the milliseconds is proving a problem.

---

My questions: 

* How can I either remove the milliseconds from the TVP, or
* Can someone tell me why the TVP is inserting the full time where the `INSERT INTO` statement is only entering up to the 'second' in the other table?