data for six months

[simma]

Hello,
How do we get data for six months from today.
Do we use datediff function?
Thanks

 

[MDXer]

you can use a between function, something like the following should work.

Select
Column1,
Column2
From MyTable
Where DateColumn Between DateAdd(mm,-6,GetDate()) and GetDate()

one Note is that the above does not exclude the Time portion of the date from the comparison. To do that you would nee to Cast(Convert(varchar,DateColumn,101) as dateTime) and do the same arourn the GetDate() calls.

The cast convert does have some overhead but I have used it with extremely large data sets and it seems to be minimal.

Shoot Me! Shoot Me NOW!!!
- Daffy Duck

 

[simma]

Thanks...