Posted by Erland Sommarskog on 06/08/06 06:56

David Portas (REMOVE_BEFORE_REPLYING_dportas@acm.org) writes:
> You can't actually format dates in a query at all. You can output a
> string that looks like a date. I know you know this Erland, but the
> difference is worth stating given that the application probably treats
> dates and strings very differently.

Well, it depends on what the application will use the output for. If it's
going into a report, it's just another string for the application. If the
application is going do some date logic with it, the result can only be
confusion.

--
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: Re: Format a datetime columns output?
• Prev in forum: Re: Question about returning a smalldatetime from a Function
• Thread view: Re: Format a datetime columns output?

[Reply to this message]