not showing proper datetime in tables

[mo/-/sin]

i made a table in sql server 2005 and there is column name
dateofjoining... but whenever i insert a value in this column it shows
some other value........
suppose i insert 2005-09-25 but it shows 1905-05-26.... why it is
happening..............

[Philipp Post]

There is not sufficient information given to expect a proper reply.
Please post DDL and the query you are executing.

If the data comes from the front end, it might be that there is a
conflict with the language settings.

Some posters advised in this group that the british english version of
SQL Server has problems with the ISO date format, and needs a format
like YYYYMMDD e.g.: 20050925.

brgds

Philipp Post

[Erland Sommarskog]

mo/-/sin (Ri*******@gmail.com) writes:

i made a table in sql server 2005 and there is column name
dateofjoining... but whenever i insert a value in this column it shows
some other value........
suppose i insert 2005-09-25 but it shows 1905-05-26.... why it is
happening..............

Sounds like you forgot to put 2005-09-25 in quotes, in which case
it becomes a numeric expression with the value 1961. 1961 is then its
turn interpreted as the number of days since the base date which is
1900-01-01 (and which is day 1).
--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinf...ons/books.mspx