entity framework on entering a datetime 1 millisecond before the next day date is getting rounded up

Question

I'm entering a datetime using the entity framework and I was trying to enter this date:

new DateTime(2011, 11, 18, 23, 59, 59, 999);

which is one millisecond before the 19th.

However when I check it in the database it keeps getting rounded up to the 19th 2011/11/19 0 0 0 000

Anyone know what's going on here and how to remedy it?

This is the type in my model:

public override DateTime? EndDate { get; set; }

score 1 · Accepted Answer · answered Nov 17 '11 at 20:12

1

May be your column type on database is date? not datetime

answered Nov 17 '11 at 20:12

Reza ArabQaeni

you say rounded up but rounded down – Reza ArabQaeni Nov 17 '11 at 20:40
ok I see what you mean I had an error in my question. Updated. – AnonyMouse Nov 17 '11 at 20:54
you right, i check this with new SqlDateTime(new DateTime(2011, 11, 18, 23, 59, 59, 999)) and return your result but with 998 not rounded – Reza ArabQaeni Nov 17 '11 at 21:07
http://stackoverflow.com/questions/1181662/is-there-any-difference-between-datetime-in-c-sharp-and-datetime-in-sql-server/1181668#1181668 – Reza ArabQaeni Nov 17 '11 at 21:14
Thanks for the help. I've now found that I have 3 nanosecond precision and you can't even set the precision in Sql Management Studio it keeps rounding it. – AnonyMouse Nov 17 '11 at 22:48

1 Answers1