|
Posted by rune on 09/25/07 10:00
Hi
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 ?
Regards
Rune
Navigation:
[Reply to this message]
|