Syntax
DATENAME(datepart, date)

Arguments
datepart
Is the parameter that specifies the part of the date to return. The table
lists dateparts and abbreviations recognized by Microsoft® SQL Server(tm).


Datepart Abbreviations
year yy, yyyy
quarter qq, q
month mm, m
dayofyear dy, y
day dd, d
week wk, ww
weekday dw
hour hh
minute mi, n
second ss, s
millisecond ms

-----Original Message-----
From: Parag Kulkarni [mailto:[Email Address Removed] Tuesday, May 14, 2002 11:16 AM
To: [Email Address Removed] Select Day As String


Hi Freinds,


I need to get day in string format ( AS SUNDAY ) for a
given date.I checked the BOL but couldnt find it.Does
somebody knows this.I am using SQL 2000.

Thanks in advance
Parag

__________________________________________________
Do You Yahoo!?
LAUNCH - Your Yahoo! Music Experience
http://launch.yahoo.com

---------------------------------------------------------------------
To unsubscribe, e-mail: mssqldba-[Email Address Removed] additional commands, e-mail: mssqldba-[Email Address Removed]MS Sql Server LazyDBA home page