Forum Discussion

micro21's avatar
micro21
Copper Contributor
Aug 12, 2021

SQL server table datetime column value

Below values are generating for the DateTime column:

1/1/1900

1/1/1901

1/1/1902

1/1/1903

How these values are different every time?

Are they based on the SQL server version?

  • olafhelper's avatar
    olafhelper
    Bronze Contributor

    micro21 , That's to less on information.

     

    Below values are generating for the DateTime column:


    How generate that values? SQL Server generates data only when you code it in some way.

    Please post table design as DDL, some sample data as DML statement.

Resources