Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Can I set the time range to get 3 month data in SQL script?
Yes, I realized that. Thank you!!- klearn98
- Post #6
- Forum: Microsoft SQL Server: Programming
-
Can I set the time range to get 3 month data in SQL script?
George and DaveInIowa, Thank you so much to both of you!!! Both codes work well. DaveInIowa's code is simple and easy. But like George mentioned, the data type of my timestamp is datatime, so subtract day might not get all data in that date. So I will do pp.timestamp >= DateAdd(Month, -3 +...- klearn98
- Post #4
- Forum: Microsoft SQL Server: Programming
-
Can I set the time range to get 3 month data in SQL script?
Hi, I have a script that need to be run automatically in the first day of each month and get the previous 3 month data. How can I write a SQL expression to set the time range? For example, if the script runs on 5/1/2013, the data should include 02/01/2013 to 04/30/2013. Now I am doing it this...- klearn98
- Thread
- Replies: 5
- Forum: Microsoft SQL Server: Programming
