By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,575 Members | 1,968 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,575 IT Pros & Developers. It's quick & easy.

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

P: 27
Help Me To Make this Function...
Jan 6 '10 #1
Share this Question
Share on Google+
3 Replies


code green
Expert 100+
P: 1,726
Do you mean tomorrows date?
Expand|Select|Wrap|Line Numbers
  1. SELECT CONVERT(VARCHAR,DATEADD(DAY,+1,GETDATE()),23)
Jan 6 '10 #2

nbiswas
100+
P: 149
If you are looking for

A) NEXT DATE
Expand|Select|Wrap|Line Numbers
  1. SELECT TomorrowDate = CONVERT(VARCHAR(10),GETDATE()+1,25) 
Expand|Select|Wrap|Line Numbers
  1. NextDate
  2. 2010-01-08
B) NEXT DAY
Expand|Select|Wrap|Line Numbers
  1. SELECT NextDay = DAY(GETDATE())+1
Expand|Select|Wrap|Line Numbers
  1. NextDay
  2. 8
C) NEXT DAY NAME

Expand|Select|Wrap|Line Numbers
  1. SELECT NextDayName = DATENAME(dw, GETDATE()+1)
Expand|Select|Wrap|Line Numbers
  1. NextDayName
  2. Friday
Jan 7 '10 #3

P: 27
thanks Biswas i think i can take a speed now...
GURU hai to Gati Hai..
Jan 7 '10 #4

Post your reply

Sign in to post your reply or Sign up for a free account.