Hi,

I created this stored procedure in SQL 2000 to add 90 days to the current date, and return the new date:

CREATE PROCEDURE Get90Days
AS
SELECT DATEADD(day, 90, current_timestamp) AS "RETURNDAYS"

Run today, July 1, 2006, the procedure above returns this result:

2006-09-29 07:31:14.477

I need this procedure to return the date, only, like this:

09-29-2006

I tried using the convert switch to reformat the result but have not been successful.

What does this stored procedure need to look like to return just the date, like this:

09-29-2006

Thanks,
Bill

Why would you return a VARCHAR? You can't sort varchar dates, unless thery are stored yyyy-mm-dd.

CREATE PROCEDURE Get90Days
AS
SELECT CONVERT(VARCHAR(10), DATEADD(day, 90, GETDATE()), 110) ReturnDays

Hi Peso,

Thank you! This has been haunting me!

I want to return a vchar to load into a form, so the result does not have to be sorted.

Thanks, Peso, again for your help!
Bill