H0W Could i Get Next Day Date Of the Day Function in the Sql server 2000.

**code green** · Jan 6 '10, 11:11 AM

Do you mean tomorrows date?

Code:

SELECT CONVERT(VARCHAR,DATEADD(DAY,+1,GETDATE()),23)

**nbiswas** · Jan 7 '10, 02:53 AM

Solution to H0W Could i Get Next Day Date Of the Day Function in the Sql server 2000

If you are looking for

A) NEXT DATE

Code:

SELECT TomorrowDate = CONVERT(VARCHAR(10),GETDATE()+1,25)

Code:

NextDate
2010-01-08

B) NEXT DAY

Code:

SELECT NextDay = DAY(GETDATE())+1

Code:

NextDay
8

C) NEXT DAY NAME

Code:

SELECT NextDayName = DATENAME(dw, GETDATE()+1)

Code:

NextDayName
Friday

**MrMob** · Jan 7 '10, 08:06 AM

thanks Biswas i think i can take a speed now...
GURU hai to Gati Hai..

Comment