sql - SQL查询以在SQL Server中插入日期时间(Sql query to insert datetime in SQL Server)

Question

I want to insert a datetime value into a table(SQL Server) using the sql query below

(我想使用下面的SQL查询将datetime值插入表（SQL Server）中)

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

(我收到此错误消息Cannot convert varchar to datetime)

Kindly help!

(请帮助！)

Thanks.

(谢谢。)

  ask by Shee translate from so

Answer 1

You will want to use the YYYYMMDD for unambiguous date determination in SQL Server.

(您将需要使用YYYYMMDD来确定SQL Server中的明确日期。)

insert into table1(approvaldate)values('20120618 10:34:09 AM');

If you are married to the dd-mm-yy hh:mm:ss xm format, you will need to use CONVERT with the specific style.

(如果您已采用dd-mm-yy hh:mm:ss xm格式，则需要使用具有特定样式的CONVERT。)

insert table1 (approvaldate)
       values (convert(datetime,'18-06-12 10:34:09 PM',5));

5 here is the style for Italian dates.

(5是意大利约会的风格。)

Well, not just Italians, but that's the culture it's attributed to in Books Online .

(好吧，不仅是意大利语，这就是它在Online Books中归因于的文化。)