C# code to save datetime format in 01/01/1900 hh:mm:ss

Question

Dear I am in a winform project and needed help from someone on below issue. I need a datetime format of 01/01/1900 hh:mm:ss to insert into table. The current below code not working for me with output - 2017-12-14 16:07:40.000 string .Format( {0:hh:mm:ss}  DateTime .Now.ToString()); format needed :- 1900-01-01 16:07:40.000. Thank you.

Dharmraj Thakur · Answer

Try this... Console.Write(DateTime.Now.ToString(dd-MM-yyyy hh:mm:ss:ms));

Amit Gupta · Answer

Donot convert DateTime .ToString(); Use only DateTime like DateTime.Now.ToString(dd-MM-yyyy hh:mm:ss); And to save in the database use only DateTime format not the string format of it. I had just updated the post Do let me know if it works

Bharathi Raja · Answer

var updateCommand = new SqlCommand( UPDATE [User] SET Last_loign_date =@LastLoginDate conn); //Assume conn is an SqlConnection object updateCommand.Parameters. Add ( @LastLoginDate SqlDbType.DateTime).Value = DateTime.Now

Bineesh Viswanath · Answer

Dear Amit The code you gave is showing like input string was not in a correct format.