blogs.conchango.com

Browse by Tags

• case statement
• Date
• last_day
• List of dates
• MTD
• next_day
• Oracle
• PL/SQL
• PL-SQL
• SQL
• T-SQL
• Week Ending
• YTD

• PL/SQL Calendar table

  In addition to the T-SQL calendar table , which I have posted seperately, I went the whole hog and figured out the equivalent for Oracle. The only value I couldn't work out was the millisecond, which is not present on the standard date type in Oracle, Read More... Posted 24 April 2007 16:00 by James.Pipe | 4 Comments Filed under: PL/SQL, PL-SQL, SQL, Date functions, Date, Date range

• T-SQL Calendar table

  After experimentation with various datepart and datename methods following my most recent blog post , I was able to identify many if not all the necessary components for constructing a calendar table.To do this I have combined these functions with the Read More... Posted 24 April 2007 15:51 by James.Pipe | 3 Comments Filed under: SQL, T-SQL, Date functions, Date, Date range

• PL/SQL and T-SQL for Week Ending Date

  Recently my colleague challenged me to find a method for identifying the week ending date for the week which any given date belongs to; i.e. say for a gven date which happens to be a Tuesday, what is the date of the end of the week? In this example, week Read More... Posted 24 April 2007 15:01 by James.Pipe | 9 Comments Filed under: PL/SQL, List of dates, SQL, T-SQL, next_day, Date functions, Date, Date range, Week Ending

• T-SQL: Common date ranges; Daily, Weekly, Monthly, Yearly, Last 12 Months

  As promised in my original post on PL/SQL date ranges previously, below is a sql statement which can be used preceeding most queries in order to apply common date range lookups to the data the query returns. SQL Server Management Studio (SSMS) doesn't Read More... Posted 01 March 2007 00:34 by James.Pipe | 2 Comments Filed under: SQL, T-SQL, case statement, Date functions, Date, Date range, MTD, 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