I have the folloing code for a RadTimePicker but for some reason in my page behind when I submit a query to the database with tpEndTime formatted as a string it is inputting the date and time in to the database column, not just the time. The db table column that has the issue is set to nvarchar and there are no formatting calls on the field before the insert.
Dim dEndTime As String = tpEndTime.SelectedDate
So instead of 18:00 my database is showing 8/22/2011 18:00:00 PM
<telerik:RadTimePicker ID="tpEndTime" runat="server" Skin="Vista">
<DateInput DateFormat="HH:mm" DisplayDateFormat="HH:mm" runat="server"></DateInput>
<TimeView ShowHeader="true" HeaderText="End Time" Interval="00:15:00" Columns="4" StartTime="08:00:00" EndTime="20:00:00" TimeFormat="HH:mm" runat="server"></TimeView>
</telerik:RadTimePicker>
I am using the latest version of the ASP.net AJAX controls
Dim dEndTime As String = tpEndTime.SelectedDate
So instead of 18:00 my database is showing 8/22/2011 18:00:00 PM
<telerik:RadTimePicker ID="tpEndTime" runat="server" Skin="Vista">
<DateInput DateFormat="HH:mm" DisplayDateFormat="HH:mm" runat="server"></DateInput>
<TimeView ShowHeader="true" HeaderText="End Time" Interval="00:15:00" Columns="4" StartTime="08:00:00" EndTime="20:00:00" TimeFormat="HH:mm" runat="server"></TimeView>
</telerik:RadTimePicker>
I am using the latest version of the ASP.net AJAX controls