I am inserting a time value e.g. 10:00 from a web form, this has been working fine but since making some changes to the sproc I am getting a syntax error on the time value. It seems that the web form is sending the time as 10:00, but sql is expecting '10:00', can anyone advise how to overcome this problem?
I am using a control parameter on the web form:
<asp:ControlParameter Name="StartTime" ControlID="TxtStart" PropertyName="Text" ConvertEmptyStringToNull="true" />
many thanks in advance