using query how to next day date in the sql server

Question

0.00/5 (No votes)

See more:

i am using sql server, in that using query how to get the next day date in the sql server.

if suppose 7/4/2013

i want the output as follows 8/4/2013.

how can i get the above output using sql server.

Please help me

Regards
Narasiman P

Posted 3-Apr-13 5:52am

Member 8054539

Add a Solution

2 solutions

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Richard C Bishop · Answer 1 · 2013-04-03T05:56:00

Solution 1

Do this:

DATEADD(day, 1 , "your date" )

Posted 3-Apr-13 5:56am

Richard C Bishop

Maciej Los · Answer 2 · 2013-04-03T06:58:00

Solution1 (by richcb) is very good, but i want to show you little trick. Of course, you can use DATEADD[^] function, but see below example:

SQL

DECLARE @myDate DATETIME

SET DATEFORMAT dmy;

SET @myDate = '07/04/2013'

SELECT @myDate AS MyDate1, DATEADD(dd,1,@myDate) AS MyDate2, @myDate + 1 AS MyDate3

The same you can achieve using simply + 1.

using query how to next day date in the sql server

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

using query how to next day date in the sql server

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

Existing Members

...or Join us