Posted by Erland Sommarskog on 09/25/07 21:00

(rune@totalweb.no) writes:
> I'm trying to convert an SQL Query from Access to SQL Server. The
> Access Query goes like this:
>
> SELECT Format(EntryDate, 'ddd mm dd') AS [Day]
> FROM JournalEntries
>
> This query returns the name of the day followed by month and date (Su
> aug 21)
>
> What would this be like in SQL Server ? What style id do I have to use
> to get the correct format ?

select convert(varchar(11), EntryDate)

For more options on date formatting, look up the topic on Cast and Convert
in Books Online.

The best is to return the date a datetime value to the client, and let
the client do the formatting.


--
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: Clustered index on the identity column or a datetime column
• Prev in forum: Re: autoincrement question sql 2005 server
• Thread view: Re: SQL Query from Access to SQL Server

[Reply to this message]