SQL Query from Access to SQL Server

[rune@totalweb.no]

Hi

I'm trying to convert an SQL Query from Access to SQL Server. The
Access Query goes like this:

SELECT Format(EntryDat e, '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 ?


Regards
Rune

[Erland Sommarskog]

Re: SQL Query from Access to SQL Server

(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(EntryDat e, '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@sommarsk og.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