-----------------------------------------------------------
New Message on BDOTNET
-----------------------------------------------------------
From: maheshwarisonia
Message 4 in Discussion
Hello Sukh,
Create a user define function for ur requirement.
create function getDay(@dt as datetime)
returns varchar(10)
as
begin
declare @dayOfTheWeek int
declare @DayVal varchar(10)
set @dayOfTheWeek=datepart(dw,@dt)
if @dayOfTheWeek=1
set @DayVal='Sunday'
if @dayOfTheWeek=2
set @DayVal='Monday'
if @dayOfTheWeek=3
set @DayVal='Tuesday'
if @dayOfTheWeek=4
set @DayVal='Wednesday'
if @dayOfTheWeek=5
set @DayVal='Thusday'
if @dayOfTheWeek=6
set @DayVal='Friday'
if @dayOfTheWeek=7
set @DayVal='Saturday'
return @dayVal
end
For Calling this function use this statement.
select dbo.getDay(getDate())
_________________________________________________________________
A Camera Sells every 2 Minutes on eBay. Get Your's at a Great Price Now!
http://adfarm.mediaplex.com/ad/ck/4686-26272-10936-699?ck=Cameras
-----------------------------------------------------------
To stop getting this e-mail, or change how often it arrives, go to your E-mail
Settings.
http://groups.msn.com/bdotnet/_emailsettings.msnw
Need help? If you've forgotten your password, please go to Passport Member
Services.
http://groups.msn.com/_passportredir.msnw?ppmprop=help
For other questions or feedback, go to our Contact Us page.
http://groups.msn.com/contact
If you do not want to receive future e-mail from this MSN group, or if you
received this message by mistake, please click the "Remove" link below. On the
pre-addressed e-mail message that opens, simply click "Send". Your e-mail
address will be deleted from this group's mailing list.
mailto:[EMAIL PROTECTED]
