SQL server table datetime column value

Copper Contributor

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?

1 Reply

@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.