converting sql datetime to just time in c#

[M.Smith]

I am returning a datetime from SQL and need to populate a field with just
the time...

I have tried:

DateTime.Parse(TheTime.Hour.ToString()) + ":" +
DateTime.Parse(TheTime.Minute.ToString();

But that does not return the correct HOUW format.

Any suggestions?

Marty

[Mythran]

"M.Smith" <ma****@bennyhinn.org> wrote in message
news:up**************@TK2MSFTNGP09.phx.gbl...

I am returning a datetime from SQL and need to populate a field with just
the time...

I have tried:

DateTime.Parse(TheTime.Hour.ToString()) + ":" +
DateTime.Parse(TheTime.Minute.ToString();

But that does not return the correct HOUW format.

Any suggestions?

Marty

Hmm...so you want to put the time into a textbox?

txtTextBox.Text = TheTime.ToString("hh:MM")

I believe it is hh:MM, if not, try HH:MM.

Mythran

[M.Smith]

I am using C# and that does not work...it compiles with an error :

"No overload for method 'ToString' takes '1' arguments"

I will keep looking - any other suggestions I am open to...


"Mythran" <ki********@hotmail.comREMOVETRAIL> wrote in message
news:eG**************@TK2MSFTNGP09.phx.gbl...

"M.Smith" <ma****@bennyhinn.org> wrote in message
news:up**************@TK2MSFTNGP09.phx.gbl...

I am returning a datetime from SQL and need to populate a field with just
the time...

I have tried:

DateTime.Parse(TheTime.Hour.ToString()) + ":" +
DateTime.Parse(TheTime.Minute.ToString();

But that does not return the correct HOUW format.

Any suggestions?

Marty

Hmm...so you want to put the time into a textbox?

txtTextBox.Text = TheTime.ToString("hh:MM")

I believe it is hh:MM, if not, try HH:MM.

Mythran

[M.Smith]

drG.GetDateTime(0).ToShortTimeString();

Thanks !!

"M.Smith" <ma****@bennyhinn.org> wrote in message
news:up**************@TK2MSFTNGP09.phx.gbl...

I am returning a datetime from SQL and need to populate a field with just
the time...

I have tried:

DateTime.Parse(TheTime.Hour.ToString()) + ":" +
DateTime.Parse(TheTime.Minute.ToString();

But that does not return the correct HOUW format.

Any suggestions?

Marty