Does SqlDbType.DateTime not store seconds?

Question

using System.Data;
using System.Data.SqlClient;

I am using a SqlCommand cmd.Parameters of SqlDbType.DateTime to create a record in the database.

Seconds are not being stored in the database. The field in the db is of type datetime.

Do I need to do something special to save seconds, or does SqlDbType.DateTime not do that?

Are you positive the parameter value has seconds? – dotjoe Jun 29 '09 at 20:38 — dotjoe, Jun 29 '09 at 20:38

score 4 · Accepted Answer · edited Feb 06 '17 at 07:35

4

SqlDbType.DateTime maps to SQL's DATETIME datatype, which is accurate to 3.33 milliseconds. It sounds like you may be putting your values into a SMALLDATETIME field in SQL server, which is only accurate to the minute. SqlDbType.DateTime parameter would be the correct choice for use with both DATETIME and SMALLDATETIME.

edited Feb 06 '17 at 07:35

Safa

178
1
12

answered Jun 29 '09 at 20:41

Scott Ivey

40,768
21
80
118

score 0 · Answer 2 · answered Jun 29 '09 at 20:41

SQL Server DateTime stores time with millisecond accuracy (not quite right it rounds to .003 .007 etc)

Smalldatetime, however, stores dates such that the seconds are always :00. You have probably used smalldatetime.

http://msdn.microsoft.com/en-us/library/ms182418.aspx

Does SqlDbType.DateTime not store seconds?

2 Answers2