asked on 7/22/2015

sql DateDiff help

I need to show the record that is 24 hours priors of session start.

CASE WHEN isNULL(s.repost,0) = 1 
		THEN 
			DateDiff(hh,SU.sessionStart,GETDATE()) 
		ELSE 
			datediff(d, getdate(), SU.sessionStart) 
		END
 >= CASE WHEN isNULL(s.repost,0) = 1 
		THEN 
			24
		ELSE 
			3
		END

Open in new window

Microsoft SQL Server Microsoft SQL Server 2008 SQL

Last Comment

Vitor Montalvão

8/5/2015

ASKER CERTIFIED SOLUTION

Mike Eghtebas

7/22/2015

THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.

View this solution by signing up for a free trial.

Members can start a 7-Day free trial and enjoy unlimited access to the platform.

See Pricing Options

Start Free Trial

PortletPaul

7/23/2015

I'm sorry but I don't understand the question as the sql in the question make no sense from line 7 onward

Please remember that THE BEST WAY TO ASK is to provide:

a. sample data
b. the expected result

If we understand the question easily you get an answer faster and you don't need to clarify the question for us.

awking00

7/23/2015

select ...
where dateadd(d,1,SU.sessionStart) >= getdate()

Vitor Montalvão

8/5/2015

erikTsomik, do you still need help with this question?