cannot format date

[junkone]

i cannot seem to change the format of the string coming from the Time object.
string myInsertQuery = String.Format("insert into scans_logs (symbol, datetime,message) values ('{0}','{1:u}','{2}')",Instrument.FullName,Time,st r);

i am expecting a datetime format like

"2008-03-09 16:05:07Z"

but i keep getting a dateformat like
'2009-05-31 22:05:00 PM',

how do i avoid getting the PM from the dateformat.
ref:

http://www.csharp-examples.net/string-format-datetime/

[NinjaTrader_Bertrand]

junkone, you can check the DateTime class member methods for conversion options for this - http://msdn.microsoft.com/en-us/libr...rs(VS.80).aspx

[junkone]

i can easily convert the datetime object to any format i want. i just cannot convert the Time object. I am not sure why?

[NinjaTrader_Bertrand]

Time is a DateTime object, you try formatting it as a String with String.Format

[junkone]

if you look at post # 1, thats excactly that i am trying and it fails to format correctly.
when i use a regular DateTime.now , it works. so i am not sure why the Time object is not able to be string formatted.

[NinjaTrader_Bertrand]

I compared both DateTime.Now and Time[0] on my end and they both return a DateTime object as expected.