日期类型
create table #test
(ino int,
price float,
idate varchar(20))
insert #test values(1001,20.00,1998-01-01)
insert #test values(1001,30.00,1999-02-02)
insert #test values(1002,45.00,2006-10-10)
insert #test values(1002,34.00,2005-07-07)
insert #test values(1002,32.00,2007-01-01)
insert #test values(1003,10.00,2000-09-09)
最后查询的时候,结果是
1001 20.0 1996
1001 30.0 1995
1002 45.0 1986
1002 34.0 1991
1002 32.0 2005
1003 10.0 1982
为什么日期都变了啊,请大虾指教一下