• 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