SQL2008 Time datatype - 00:00:00 throws syntax error

Hi Experts,

Bit baffled, I'm testing a stored procedure on SQL2008 which is a very simple insert, one of the datacolumns is set to Time so I am entering a value in the format 00:00:00 - but I get a syntax error on the first colon...am I missing something here?!
forstersAsked:
Who is Participating?
 
DoutorApedeutaCommented:
Didn,t you forget the quote characters? '00:00:00'
Is the data type of the table you are inserting into the same as the SP parameter?
0
 
forstersAuthor Commented:
Hi,
Apologies, you're right - would help if I read the reply properly!

I didn't realise Time had to be in quotes.

Many thanks
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.