Posted by Erland Sommarskog on 07/29/05 17:53

Zero.NULL (manish19@gmail.com) writes:
> Erland, What i believe his problem is,
> when he is trying to show date like "07/26/2005" while he is getting
> "2006-07-26 00:00:0"

Of course, we could start some betting on what output Fernand really
wants. I think my odds are better. 2006-07-26 is a well-formatted date,
and complies with international standards. 07/26/2005 does not even look
like a date to most people in this world. I seem to recall that there
is one country where they use this format, but Fernand does not seem
to live there.




--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp

[Back to original message]