Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 309
  • Last Modified:

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?!
0
forsters
Asked:
forsters
1 Solution
 
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

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now