insert time from asp:textbox to time(0) column in sql 2008

hi Experts,

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
forstersAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

PortletPaulEE Topic AdvisorCommented:
SQL has not changed its mind on how time should be expressed, it has always needed the single quotes.

But if the change is in the sproc then comparing before and after sproc code would help.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
forstersAuthor Commented:
hi, thanks for your comment, the sproc has changed but the time columns were in the original and haven't been altered. Prior to this change we migrated the db over from sql 2008 to sql 2012, although this error has only come to light now that I have made some amends to the sproc - all I have done is add some additional parameters so I am a little confused.
0
forstersAuthor Commented:
hmm I've rolled back to the original sproc and webform and resolved the error so I will re-add each new param individually and see what happens.
0
forstersAuthor Commented:
Apologies a series of errors on my part but thank you for pointing out the obvious, sighs. Thank you!
0
PortletPaulEE Topic AdvisorCommented:
if it ain't broke don't fix it...
or,
always look where the changes have been made...

I get it. sigh. best of luck. we all been there.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
ASP.NET

From novice to tech pro — start learning today.