Posted by Erland Sommarskog on 08/25/07 08:26

rdraider (rdraider@sbcglobal.net) writes:
> Unfortunately I have no control over the format of the data in SQL nor the
> application. I am however expected to please the users :-/
> Time for a new job. I've always wanted to be a pilot...

Yes, that's the point with returning the date as datetime. The client
settings takes full control, so that each user can get the date the way
he prefers.


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

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

• Next in forum: MI5 Persecution: BBC1 TV News - 18/Dec/2002 (7598)
• Prev in forum: MI5 Persecution: Channel Four TV News - 10/April/2002 (6375)
• Thread view: Re: Convert CHAR YYYYMMDD to mm/dd/yyyy

[Reply to this message]