SQL server table datetime column value

%3CLINGO-SUB%20id%3D%22lingo-sub-2639725%22%20slang%3D%22en-US%22%3ESQL%20server%20table%20datetime%20column%20value%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2639725%22%20slang%3D%22en-US%22%3E%3CP%3EBelow%20values%20are%20generating%20for%20the%20DateTime%20column%3A%3C%2FP%3E%3CP%3E1%2F1%2F1900%3C%2FP%3E%3CP%3E1%2F1%2F1901%3C%2FP%3E%3CP%3E1%2F1%2F1902%3C%2FP%3E%3CP%3E1%2F1%2F1903%3C%2FP%3E%3CP%3EHow%20these%20values%20are%20different%20every%20time%3F%3C%2FP%3E%3CP%3EAre%20they%20based%20on%20the%20SQL%20server%20version%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2643964%22%20slang%3D%22en-US%22%3ERe%3A%20SQL%20server%20table%20datetime%20column%20value%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2643964%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1126766%22%20target%3D%22_blank%22%3E%40micro21%3C%2FA%3E%26nbsp%3B%2C%26nbsp%3BThat's%20to%20less%20on%20information.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CBLOCKQUOTE%3E%3CP%3EBelow%20values%20are%20generating%20for%20the%20DateTime%20column%3A%3C%2FP%3E%3CHR%20%2F%3E%3C%2FBLOCKQUOTE%3E%3CP%3EHow%20generate%20that%20values%3F%20SQL%20Server%20generates%20data%20only%20when%20you%20code%20it%20in%20some%20way.%3C%2FP%3E%3CP%3EPlease%20post%20table%20design%20as%20DDL%2C%20some%20sample%20data%20as%20DML%20statement.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Visitor

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.