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
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Date function...help!

Author  Topic 

brendalisalowe
Constraint Violating Yak Guru

269 Posts

Posted - 2004-08-09 : 17:26:51
I need to do something like this and have it return a value:

GetDate() - '2/16/1978' = ????

What is the SQL statement to do that? Thanks!

Brenda

Pat Phelan
Posting Yak Master

187 Posts

Posted - 2004-08-09 : 17:31:34
I'd bet that you want DateDiff().

-PatP
Go to Top of Page

brendalisalowe
Constraint Violating Yak Guru

269 Posts

Posted - 2004-08-09 : 17:33:52
Yep! Forgot about that one. Thanks!
Go to Top of Page
   

- Advertisement -