Posted by David Portas on 06/07/06 19:40

CK wrote:
> Hi All,
> Currently the query returns 2006-03-27 00:00:00, can I make it output
> 03/27/2006, I want to truncate the time, and replace the hyphens with
> forward slashes. Any ideas?
>
> Thanks In Advance,
> ~CK

SQL Server has no control over how dates are displayed. You need to fix
the formatting in your client application or development environment.
It's hard to help you because you haven't told us what your client
environment is.

--
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: Re: Challenge: Can you optimize this? (summary)
• Prev in forum: Format a datetime columns output?
• Thread view: Re: Format a datetime columns output?

[Reply to this message]