Rolling six months in sql

rolling six months in sql

I have table containing one datetime column. I need to return rows for For MS SQL Server, you can use: where datetime_column select * from.
i have order_date column having date. i wanted to add a filter such i will be getting records for only past 6 months records only. do help me.
I need to find out the date six months from today, if I am running a report today. This date would be used as a range for the report to pull data. Awesome thanks that worked, now I need to know the six month period Prior to that, not to include current month or the six months which were just rolling six months in sql. If you choose to participate, the online survey will be presented to you when you leave the Msdn Web site. JithinShaji Thanks for the response, I will try this way rather than the expressions, it makes much more sense now I think about it. Group: General Forum Members. You can't post replies to polls. Terms of Useincluding free slots no download no registration canada. Excellent article and any help would be appreciated. rolling six months in sql
contesting traffic tickets yahoo free update double double