469,337 Members | 6,157 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,337 developers. It's quick & easy.

not showing proper datetime in tables

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..............
Aug 18 '08 #1
2 1526
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
Aug 18 '08 #2
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

Aug 18 '08 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

3 posts views Thread by Neil | last post: by
3 posts views Thread by nbohana | last post: by
6 posts views Thread by JFieseler | last post: by
5 posts views Thread by iulian.ilea | last post: by
1 post views Thread by gandhi.vishal | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by suresh191 | last post: by
1 post views Thread by Marylou17 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.