blogs.conchango.com

Browse by Tags

• case statement
• Date
• Date functions
• Date range
• MTD
• Oracle
• SQL
• YTD

• PL-SQL: Common date range lookups; Daily, Weekly; MTD; YTD; Last 12 Months

  As part of my current role as a tester I am often required to write the same basic expressions again and again in my queries, most noticeably to bring back data for specific date ranges, therefore for the benefit of anyone else out there who has to do Read More... Posted 10 February 2007 04:00 by James.Pipe | 11 Comments Filed under: Oracle, PL-SQL, SQL, next_day, last_day, Date functions, Date, Date range, MTD, YTD

• Selecting the last weekday in a given month

  In one of my frequent trips through Google on the search for how to do something (I forget what it was I was looking for on this particular occasion), I found myself, as I often do, being directing to various contributions from posts on life after coffee.com Read More... Posted 03 February 2007 20:33 by James.Pipe | 2 Comments Filed under: Oracle, PL-SQL, SQL, case statement, next_day, last_day, Date functions