DateTime Format problem

[ArizonaState]

I have a situation where I need to update a table with a time retrieved from a dropdown list.

CODE...

cmd.SqlParameters.Add((@StartTime, SqlDataType.DateTime).Value =
CDate(DropDownList.SelectedItem.Text)

CODE/

While it does update the tabel row with a portion of the data (for ex.. 9/28/2007 12:00:00). I don't need the date part of the data, because all I am interested in is the time. So when the time in the dropdownlist is 4:30:00 pm, I want that time to be retrieved. Any help is appreciated.

Thanks,

Phoenix

[Ranjan kumar Barik]

I have a situation where I need to update a table with a time retrieved from a dropdown list.

CODE...

cmd.SqlParameters.Add((@StartTime, SqlDataType.DateTime).Value =
CDate(DropDownList.SelectedItem.Text)

CODE/

While it does update the tabel row with a portion of the data (for ex.. 9/28/2007 12:00:00). I don't need the date part of the data, because all I am interested in is the time. So when the time in the dropdownlist is 4:30:00 pm, I want that time to be retrieved. Any help is appreciated.

Thanks,

Phoenix

Hi,
Just format the date you retrieved from the dropdownlist using vbscript "FormatDateTime()" function and then update the table.

Let me inform if it does not work.
Thanks

[ArizonaState]

Hi,
Just format the date you retrieved from the dropdownlist using vbscript "FormatDateTime()" function and then update the table.

Let me inform if it does not work.
Thanks

Thanks for responding...

I will try it, but is it in the form...
"FormatDateTime(hh:mm, variable_name)"?

In the meanwhile I tried ...

CODE..

Convert(Datetime,StartTime,108) from TableB

/CODE

.. didn't work. But I will give yours a shot. Let me know the syntax.

Thanks,

Phoenix

[Ranjan kumar Barik]

Thanks for responding...

I will try it, but is it in the form...
"FormatDateTime(hh:mm, variable_name)"?

In the meanwhile I tried ...

CODE..

Convert(Datetime,StartTime,108) from TableB

/CODE

.. didn't work. But I will give yours a shot. Let me know the syntax.

Thanks,

Phoenix

Hi
The code is;

FormatDateTime(date, format)

"format" takes parameters: 0, 1, 2, 3, 4.
"3" for hh:mm:ss
"4" for hh:mm
You just choose the parameter you want format your date.

[jhardman]

...
Phoenix

I thought ASU was in Tempe. Hmm... Pheonix?

Anyway, welcome to the Scripts Developer Network. Notice that there is a button provided (marked - # -) that puts your code within a code block.

Jared

[ArizonaState]

I thought ASU was in Tempe. Hmm... Pheonix?

Anyway, welcome to the Scripts Developer Network. Notice that there is a button provided (marked - # -) that puts your code within a code block.

Jared

Yes, ASU is in Tempe, but I live in Phoenix... about a couple of miles from school.