Change DateTime.Now format to ISO 8601

[raulbolanos]

Hello guys,

I get this time from DateTime.Now "6/12/2009 11:45:28 AM" and I need to convert it ISO 8601 which is the one that SQL accepts "2009-12-06 11:45:28".

What can I do?

[raulbolanos]

I found a way to do this

DateTime lastTime = DateTime.Now;
string x = lastTime.ToString("u").Replace("Z", "");

but I need to do this in 1 step because I send this time by parameters, i,e:

Insert(DateTime.Now);

And I would like to send the time through it

[Plater]

SQL server takes DateTime objects as a valid parameter. There should be no need to format the output string.

However, the .ToString() function has overloads which allows you to print out the date time exactly how you want it, check msdn on it

[tlhintoq]

Hello guys,

I get this time from DateTime.Now "6/12/2009 11:45:28 AM" and I need to convert it ISO 8601 which is the one that SQL accepts "2009-12-06 11:45:28".

What can I do?

Use the ToString method to format it however you like

DateTime.Now.ToString("YYYY-MM-dd hh:mm:ss");