Posted by David Portas on 08/24/07 06:33

"rdraider" <rdraider@sbcglobal.net> wrote in message
news:Vopzi.50496$YL5.29@newssvr29.news.prodigy.net...
> Conversion necessary because the &%#%$&)# user wants to see mm/dd/yyyy
>
> Thanks
>

Well I assumed that you were storing the date as a DATETIME. What my
suggestion does is to convert a string or integer to a DATETIME. DATETIME
has NO format. So if the user wants to see it formatted some particular way
you must do that in the client application, not in SQL Server. SQL Server
has no control over how the date is displayed.

--
David Portas, SQL Server MVP

Whenever possible please post enough code to reproduce your problem.
Including CREATE TABLE and INSERT statements usually helps.
State what version of SQL Server you are using and specify the content
of any error messages.

SQL Server Books Online:
http://msdn2.microsoft.com/library/ms130214(en-US,SQL.90).aspx
--

• Next in forum: how can i send mail by using sql server
• Prev in forum: Re: Convert CHAR YYYYMMDD to mm/dd/yyyy
• Thread view: Re: Convert CHAR YYYYMMDD to mm/dd/yyyy

[Reply to this message]