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 Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Previous month of previous year?
Hello, I am trying to find the proper syntax to obtain records that are from the previous month (from current sysdate) of the previous year. For example, we are now in Feb. 2006 and I would like all records from Jan. 2005. I have this (which parses OK), but does not return the correct records...- patdools
- Thread
- Replies: 5
- Forum: Oracle: All versions
-
Date Logic resources
Hello, I am new to this forum and I work as a business intelligence reporting consultant. One of our consistent challenges is to author Date Logic for our report record selection using various flavors of SQL-- e.g., month-to-date, previous month, year-to-date when fiscal year is different from...- patdools
- Thread
- Replies: 1
- Forum: Microsoft SQL Server: Programming
