Case Statment with GETDATE()

[nutrotek]

I'm trying to write a CASE statement that evaluates if GETDATE() > Todays Date at 12pm. If true I want to use tomorrows date at 12pm, if false use todays date at 5 pm.

This is what I came up with:

CASE WHEN (CAST(GETDATE() AS DECIMAL (24,2))) > (CAST(GETDATE() AS DECIMAL (24,0)) + .5)
THEN (CAST(GETDATE() AS DECIMAL (24,2)) + 1.5) ELSE (CAST(GETDATE() AS DECIMAL (24,2)) + .7)
END

Not working. Where am I going wrong?

 

[gmmastros]

This may not be EXACTLY what you want, but it should be pretty close.

Select Case When DatePart(Hour, '20060810 [!]10:00:00 AM[/!]') > 12
            Then DateAdd(Hour, 12, DateAdd(Day, 1, DateDiff(Day, 0, GetDate())))
            Else DateAdd(Hour, 17, DateAdd(Day, 0, DateDiff(Day, 0, GetDate())))
            End

Change the part in red to test the functionality.

-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom

 

[MikeBronner]

Here's a slight alternative, using the current date and time:

SELECT CASE
	WHEN DATEPART(hour, GETDATE()) > 12 THEN
		DATEADD(dd, 2, DATEADD(hh, -12 - DATEPART(hh, GETDATE()), DATEADD(mi, -DATEPART(mi, GETDATE()), DATEADD(ss, -DATEPART(ss, GETDATE()), DATEADD(ms, -DATEPART(ms, GETDATE()), GETDATE())))))
	ELSE
		DATEADD(dd, 1, DATEADD(hh, -7 - DATEPART(hh, GETDATE()), DATEADD(mi, -DATEPART(mi, GETDATE()), DATEADD(ss, -DATEPART(ss, GETDATE()), DATEADD(ms, -DATEPART(ms, GETDATE()), GETDATE())))))
	END

Sorry for reposting, I had been working on it and been away from my desk, so I thought I'd add it as well, perhaps it will help.

Take Care,
Mike