here is my code cmd.Parameters.AddWithValue("@despatch_date_time", DateTime.Now); i am getting this format in despatch_date_time column : kindly suggest 2015-01-22 i want date and time both together.