22,300
社区成员




create table tb(dt datetime)
insert into tb select '2011-02-11'
insert into tb select '2011.02.11'
insert into tb select '2011/02/11'
insert into tb select '2011 02 11'
go
select * from tb
go
drop table tb
/*
dt
-----------------------
2011-02-11 00:00:00.000
2011-02-11 00:00:00.000
2011-02-11 00:00:00.000
2011-02-11 00:00:00.000
(4 行受影响)
*/
insert into 备忘录(日期,内容,记录人,记录时间) values('#2011/2/13#','家狠狠哭','肖淑芬','2011/2/13 11:45:23')
insert into 备忘录(日期,内容,记录人,记录时间) values('2011/2/13','家狠狠哭','肖淑芬','2011/2/13 11:45:23')