Hello Friends!

I am working on a website. On that website i am receiving date from user using Calender Control. I wan t to display that date in Month Day and Year format. Therefore, I want to add convert date query in my store procedure. I don't know the exact syntax for date conversion. So please friends guide me how can i insert convert date query in store procedure. Following is my store procedure


ALTER PROCEDURE [dbo].[Proc_CouponDetails_GetByID2]
          (
                   @CouponID INT
          )
 AS

BEGIN
                SET NOCOUNT ON;

SELECT
                 AD.StoreID,
                AD.TypeID,
                AD.Title,
                AD.Image,
                AD.Description,
                Code,
                AddDate,
                 Exp_Date,
                 (select FName+' '+LName from UserAccounts where ID=AD.UserID) AS UserName,
               AD.PageTitle,
               AD.PageHeading,
               AD.UserID,
               AD.MetaKeywords,
               AD.MetaDescription,
               AD.Slug,
               AMCat.NetworkID ,
               AD.Views
FROM [CouponDetails] AD WITH (NOLOCK)

INNER JOIN [CouponStores] ASCat

ON AD.StoreID = ASCat.StoreID

INNER JOIN [CouponNetworks] AMCat

ON ASCat.NetworkID = AMCat.NetworkID

WHERE CouponID = @CouponID AND AD.Inactive=0


Waiting for your guidance friends


Thanks