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?

Recommended for you: Get network issues from WhatsUp Gold. Not end users.

Answer 1

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.

Does SqlDbType.DateTime not store seconds?

Sign up