Loading

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

Bineesh Viswanath

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.

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Dharmraj Thakur8y ago
Try this...

Console.Write(DateTime.Now.ToString("dd-MM-yyyy hh:mm:ss:ms"));
0
Bharathi Raja8y ago
1. var updateCommand = new SqlCommand(
2. "UPDATE [User] SET Last_loign_date =@LastLoginDate"
3. ,conn); //Assume conn is an SqlConnection object
4. updateCommand.Parameters.Add("@LastLoginDate",SqlDbType.DateTime).Value = DateTime.Now
0