DateDiff question - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

DateDiff question

Author

Topic

masterdineen
Aged Yak Warrior

550 Posts

Posted - 2010-09-28 : 10:21:09

Hello everyone

I want to use the DateDiff function within a UDF

for example

select DateDiff (day, INVDATE , getdate())
from customer_statement_PB
where ( "the difference is more than 50" )

what is the syntax to implement the >50 criteria.

Kind Regards

Rob

MCTS / MCITP certified

pk_bohra
Master Smack Fu Yak Hacker

1182 Posts

Posted - 2010-09-28 : 10:54:15

Are you using sql server 2000 or 2005 ?

AFAIK in Sql 2K you cannot use getdate() (non-deterministic function) inside UDF. You need to pass as parameter.

In Sql 2K5 I feel we can use getdate() function.

The select will be:
select DateDiff (day, INVDATE , getdate())
from customer_statement_PB
where DateDiff (day, INVDATE , getdate()) > 50