Milliseconds are truncated when inserting DatTime in Sql Server

[Guest]

check the InternalTicks for the date1 and date and see what I mean. What the
hell?

string connString = "Data Source=(local);Initial Catalog=Test;Integrated
Security=True";
SqlCommand command = new SqlCommand("insert into Table_1
(CreateDate) values (@date)");
DateTime date1 = DateTime.Now;
command.Parameters.AddWithValue("@date", date1);

command.Connection = new SqlConnection(connString);

command.Connection.Open();
command.ExecuteNonQuery();

command.CommandText = "Select * from Table_1";
SqlDataReader reader = command.ExecuteReader();
reader.Read();
DateTime date = (DateTime)reader["CreateDate"];
reader.Close();


command.CommandText = "Delete from Table_1";
command.ExecuteNonQuery();
command.Connection.Close();

 

[Jim Hughes]

SQL Server only stores seconds with 1/3 second precision.

http://vyaskn.tripod.com/searching_date_time_values.htm

 

[Stephany Young]

Close! It's 3 millisecond precision.

SQL Server only stores seconds with 1/3 second precision.

http://vyaskn.tripod.com/searching_date_time_values.htm

check the InternalTicks for the date1 and date and see what I mean. What
the
hell?

string connString = "Data Source=(local);Initial Catalog=Test;Integrated
Security=True";
SqlCommand command = new SqlCommand("insert into Table_1
(CreateDate) values (@date)");
DateTime date1 = DateTime.Now;
command.Parameters.AddWithValue("@date", date1);

command.Connection = new SqlConnection(connString);

command.Connection.Open();
command.ExecuteNonQuery();

command.CommandText = "Select * from Table_1";
SqlDataReader reader = command.ExecuteReader();
reader.Read();
DateTime date = (DateTime)reader["CreateDate"];
reader.Close();


command.CommandText = "Delete from Table_1";
command.ExecuteNonQuery();
command.Connection.Close();

 

[Jim Hughes]

Whoops, you are right of course... Glad I included a link

Close! It's 3 millisecond precision.

SQL Server only stores seconds with 1/3 second precision.

http://vyaskn.tripod.com/searching_date_time_values.htm

check the InternalTicks for the date1 and date and see what I mean. What
the
hell?

string connString = "Data Source=(local);Initial Catalog=Test;Integrated
Security=True";
SqlCommand command = new SqlCommand("insert into Table_1
(CreateDate) values (@date)");
DateTime date1 = DateTime.Now;
command.Parameters.AddWithValue("@date", date1);

command.Connection = new SqlConnection(connString);

command.Connection.Open();
command.ExecuteNonQuery();

command.CommandText = "Select * from Table_1";
SqlDataReader reader = command.ExecuteReader();
reader.Read();
DateTime date = (DateTime)reader["CreateDate"];
reader.Close();


command.CommandText = "Delete from Table_1";
command.ExecuteNonQuery();
command.Connection.Close();