How to identify age from date 2

[jararaca]

Hi,

I have a table with a smalldatetime column. I need to identify all records in that table that have dates in that column that are six months old or older. Can someone please tell me how I might do this?

Thank you.

 

[gmmastros]

Lookup DateDiff And DateAdd in Books-On-Line.



-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom

 

[Dashley]

jararaca
you can try

select mydatacolumn from mytable where mydate < getdate() -180


180 is approx 6 months * 30 days

 

[jbenson001]

select * from <table>
where datediff(mm, getdate(), <datecol>) = 6

Jim

 

[jararaca]

Thanks both. I will try that, Dashley. Can anyone please tell me how to access books-on-line? Or just give me the syntax for DateDiff and/or DateAdd if it's not too much trouble.

Thanks.

 

[jararaca]

Thanks jbenson001! I'll give it a try.

 

[jbenson001]

Books On Line is part of the sql server installation. It should show up on your start menu -> all programs -> Microsoft SQL Server menu

 

[gmmastros]

For the internet version of books on line, see this faq's

faq183-689

-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom

 

[jbenson001]

Glad to help

Jim

 

[SQLBill]

BOL=Books OnLine=Microsoft SQL Server's HELP
Installed as part of the Client Tools
Found at Start>Programs>Microsoft SQL Server>Books OnLine
or online at:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/startsql/portal_7ap1.asp

-SQLBill

Posting advice: FAQ481-4875