| Author |
Topic |
|
maya_zakry
Constraint Violating Yak Guru
379 Posts |
 Posted - 2007-02-11 : 22:23:09
|
| hi all,can i have brief explaination of datediff and dateadd function, regarding their arguments and params, definitions.. like the books online definition.. anybody have the books online url?becoz im curious what this line do in detail(found it in [url]http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=62729[/url] : count age function and it's kewlLLl) datediff(mm,dateadd(yy,AGE_IN_YEARS,START_DATE),END_DATE)thanks~~~Focus on problem, not solution~~~ |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2007-02-11 : 22:34:38
|
"anybody have the books online url?"You mean you don't have the BOL in your local PC ? It is found in the SQL Server installation CD
KH |
 |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
|
|
maya_zakry
Constraint Violating Yak Guru
379 Posts |
Posted - 2007-02-12 : 01:28:15
|
| im sorry what is BOL? Book Online? err.. err.. i dunno if i have it or not... how to check :P...~~~Focus on problem, not solution~~~ |
|
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2007-02-12 : 01:40:37
|
BOL is Books OnLine. If you don't have it, install from the CD or download from that url
KH |
|
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2007-02-12 : 01:46:12
|
1. Go to Start, Programs, Microsoft SQL Server.2. Click on Books Online submenu.Or type this (for SQL 2000 only) in Run command in Start menu:hh C:\Program Files\Microsoft SQL Server\80\Tools\Books\sql80.col Assuming this is the path of your SQL Server installation.Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
|
|
|
maya_zakry
Constraint Violating Yak Guru
379 Posts |
Posted - 2007-02-12 : 02:09:18
|
| oh MY... it exists.. and i dont even know it!! and never use it... ohhh.. tq tq~~~Focus on problem, not solution~~~ |
|
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2007-02-12 : 02:21:13
|
quote:
Originally posted by maya_zakry
oh MY... it exists.. and i dont even know it!! and never use it... ohhh.. tq tq~~~Focus on problem, not solution~~~
This should be your first point of reference when you want to find out the syntax, answer to questions etc.
KH |
|
|
|
maya_zakry
Constraint Violating Yak Guru
379 Posts |
Posted - 2007-02-12 : 02:23:20
|
| yep.. otherwise this forum will be full of my silly q's~~~Focus on problem, not solution~~~ |
|
|
|
|
datediff and dateadd