InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comThu, 23 May 2013 18:07:26 GMT20http://www.sqlservercentral.com/Forums/Topic608918-323-1.aspxdatediff(dd,getdate(),getdate()) IS ALWAYS 0 and therefore LESS THEN 1What is the purpose of doing that?Wed, 26 Nov 2008 04:07:34 GMTA_A_R_Thttp://www.sqlservercentral.com/Forums/Topic608918-323-1.aspxIs that the solution you using or the problem you having?We still don't understand why you feel the need to test GETDATE vs GETDATE cause the answer is ALWAYS the same!!!! :hehe:Wed, 26 Nov 2008 04:04:23 GMTChristopher Stobbshttp://www.sqlservercentral.com/Forums/Topic608918-323-1.aspxHI Just see below...............select 21/ case when datediff(dd,getdate(),getdate()) <1 then 1 else datediff(dd,getdate(),getdate()) endWed, 26 Nov 2008 03:57:24 GMTjagadeesh.pitchaiahhttp://www.sqlservercentral.com/Forums/Topic608918-323-1.aspxOr is the situation something like this[code]DECLARE @TABLE TABLE(Number INT,Date1 DATETIME,Date2 DATETIME)INSERT INTO @TABLESELECT 21,GETDATE(),GETDATE() UNION ALLSELECT 21,GETDATE(),DATEADD(dd,2,GETDATE()) SELECT Number/CASE WHEN (datediff(dd,Date1,Date2)) = 0 THEN 1 ELSE (datediff(dd,Date1,Date2)) ENDFROM @TABLE[/code]Which case I used a case statement to check for 0 before dividingyou could right it differently but a case statement would work for you.ThanksChrisWed, 26 Nov 2008 03:56:59 GMTChristopher Stobbshttp://www.sqlservercentral.com/Forums/Topic608918-323-1.aspxHmm...I still don't understand what you want?This code is what I believe you're asking for:[code]select 21 / (datediff(dd,getdate(),getdate()) + 1)[/code]But you could just as easily replace (datediff(dd,getdate(),getdate()) + 1) by just 1.[code]select 21 / 1[/code]Above code is the same.Why do you want to subtract today from today ( GETDATE() - GETDATE() )? What's the purpose of doing that?Wed, 26 Nov 2008 03:55:41 GMTA_A_R_Thttp://www.sqlservercentral.com/Forums/Topic608918-323-1.aspxIs this a real life example.Cause if you always doing a date diff with GETDATE vs GETDATE then why don't you just do this.SELECT 21I think something is missing here.Do you have sample data with other examplesWed, 26 Nov 2008 03:53:31 GMTChristopher Stobbshttp://www.sqlservercentral.com/Forums/Topic608918-323-1.aspxHi Thanks for your reply..my requirement is,select 21/datediff(dd,getdate(),getdate())if I execuite above i will get an error as Msg 8134, Level 16, State 1, Line 1Divide by zero error encountered.but I want top value( ie A/datediff(dd,getdate(),getdate()), I want ans as A)the date diff is 0, but we have to make it as 1, so that I will get top value as 21.Wed, 26 Nov 2008 03:38:59 GMTjagadeesh.pitchaiahhttp://www.sqlservercentral.com/Forums/Topic608918-323-1.aspxWhat do you mean? Output of 21?In your code there's a ")" missing. Like this:select 21/(datediff(dd,getdate(),getdate())[b])[/b]But it's no good anyway.This code will give you 21 as output but I'm quite sure this is not what you mean:[code]select (datediff(dd,getdate(),getdate()) + 21)[/code]Wed, 26 Nov 2008 03:23:14 GMTA_A_R_Thttp://www.sqlservercentral.com/Forums/Topic608918-323-1.aspxselect 21/(datediff(dd,getdate(),getdate())Hi How I can get an out put of 21............Wed, 26 Nov 2008 03:09:04 GMTjagadeesh.pitchaiah