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?
Hi Mufasa, Thanks for the reply. We're playing with it and should be able to make it work. On a more general level, I've had some exposure to SQL, but need to get a lot better at it to do the web intelligence consulting I do now. I've been told to get a SQL book, but there are many out...- patdools
- Post #3
- Forum: Oracle: All versions
-
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
