12 month data

[parsql]

Hi all,

need help to figure out that how can i get last 12 month of data for any given date. i have start and end date.

should i do like datediff(mm, 12, getdate())
??
thanks

 

[SQLDenis]

where SomeValue >= dateadd(yy, -1, getdate())

or

where SomeValue >= dateadd(mm, -12, getdate())


test with this
select dateadd(yy, -1, getdate())
select dateadd(mm, -12, getdate())

Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

Personal Blog:

http://otherthingsnow.blogspot.com/

 

[SQLDenis]

change getdate to DATEADD(dd, DATEDIFF(dd, 0, getdate())+0, 0) to strip of the time

where SomeValue >= dateadd(yy, -1, DATEADD(dd, DATEDIFF(dd, 0, getdate())+0, 0))

or

where SomeValue >= dateadd(mm, -12, DATEADD(dd, DATEDIFF(dd, 0, getdate())+0, 0))


test with this
select dateadd(yy, -1, DATEADD(dd, DATEDIFF(dd, 0, getdate())+0, 0))
select dateadd(mm, -12, DATEADD(dd, DATEDIFF(dd, 0, getdate())+0, 0))

Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

Personal Blog:

http://otherthingsnow.blogspot.com/