September 16, 2004 at 11:20 pm
While refering the updated books online of sql server 2000 ..:
Transact sql reference->functions->datetime functions
I found that "datename()" function is stated as non deterministic function.
I think its deterministic function.
What u think ? its books online mistake? or my view is wrong ?
Vidyadhar
September 19, 2004 at 6:03 pm
From BOL ("deterministic functions" in the index keyword search):
All functions are deterministic or nondeterministic:
DATENAME / DATEPART always return the same value when called with a specific set of parameters and hence is deterministic...
however something like this: SELECT DATENAME(ms,getdate()) will return different values each time -- and that is because getdate() is the Nondeterministic function affecting the deterministic function...
I think.........
p.s.: The suggestions forum (this one) is used to give suggestions related to the site to the site owners...you would be better off posting in the T-SQL or General forums with such queries...
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy