如何在表中插入日期? [英] how to insert date in table?
问题描述
我尝试了语法,插入emp值('Namrata Motiram Madame',1181,'18 -12-2012','Khalasi','18-08-1983','Speedometer(HRE)'); 但得到错误消息241,级别16,状态1,行1
从字符串转换日期和/或时间时转换失败。
我也尝试了语法,插入emp值('Namrata Motiram Madame',1181,18-12-2012,'Khalasi',18-08-1983,'Speedometer(HRE)');得到错误消息206,级别16,状态2,行1
操作数类型冲突:int与日期不兼容。我再次将日期输入,但收到错误消息207,级别16,状态1,行1
无效的列名称'18 -12-2012'。
消息207,级别16,状态1,行1
无效的列名称'18 -08-1983'。我该怎么办?
I tried the syntax, " insert into emp values('Namrata Motiram Madame',1181,'18-12-2012','Khalasi','18-08-1983','Speedometer(HRE)');" but got error "Msg 241, Level 16, State 1, Line 1
Conversion failed when converting date and/or time from character string."
I also tried the syntax," insert into emp values('Namrata Motiram Madame',1181,18-12-2012,'Khalasi',18-08-1983,'Speedometer(HRE)');" got error "Msg 206, Level 16, State 2, Line 1
Operand type clash: int is incompatible with date". Again I put date in to "",but got error "Msg 207, Level 16, State 1, Line 1
Invalid column name '18-12-2012'.
Msg 207, Level 16, State 1, Line 1
Invalid column name '18-08-1983'." what can I do?
推荐答案
阅读:如何从sql server中的字符串插入datetime - Stack Overflow [ ^ ]
这篇关于如何在表中插入日期?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!