Date time string insert to db

Question

Hi I am trying to insert the following to SQL Server 2005:

INSERT INTO tb_UserLoginTimes (UserID, LoginDateTime)
VALUES (1235,2010/07/06 10:38:44)

But am getting the following error.

Incorrect syntax near '10'.

Do I need to escape the colon?

If so how do I do that?

Real noob at this so my apologies.

Answer 1

It looks like you simply need to enclose your date in quotes:

... VALUES (1235, '2010/07/06 10:38:44')

Try it out in the SEDE. If you leave out the quotes, you'll get the same syntax error you're reporting.

Answer 2

Instead of 2010/07/06 10:38:44 use the ANSI SQL Standard (YYYYMMDD HH:MM:SS)

'20100706 10:38:44'