When I insert the datatime row into a table as below, I get different result. Any idea?
use tempdb
go
create table test1 (dat datetime)
go
insert into test1 values('1753-01-01')
select * from test1
RESULT:
1753-01-01 00:00:00.000
insert into test1 values(1753-01-01)
select * from test1
RESULT:
1904-10-18 00:00:00.000
:unsure:
Thanks
big[M]
John