Return date only...I need your help!
I created this stored procedure in SQL 2000 to add 90 days to the current date, and return the new date:
CREATE PROCEDURE Get90Days
SELECT DATEADD(day, 90, current_timestamp) AS "RETURNDAYS"
Run today, July 1, 2006, the procedure above returns this result:
I need this procedure to return the date, only, like this:
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: