I want to insert a datetime
value into a table(SQL Server) using the sql query below
insert into table1(approvaldate)values(18-06-12 10:34:09 AM);
But I get this Error msg. Incorrect syntax near '10'.
I tried it with the quotes
insert into table1(approvaldate)values('18-06-12 10:34:09 AM');
I get this error message Cannot convert varchar to datetime
Kindly help!
Thanks.
Best Answer
You will want to use the YYYYMMDD for unambiguous date determination in SQL Server.
If you are married to the
dd-mm-yy hh:mm:ss xm
format, you will need to use CONVERT with the specific style.5
here is the style for Italian dates. Well, not just Italians, but that's the culture it's attributed to in Books Online.