blogs.conchango.com

welcome to the conchango blogging site
Welcome to blogs.conchango.com Sign in | Join | Help
in Search

Browse by Tags

All Tags » SQL » next_day » Date functions
  • 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 ending is defined as a Sunday, however depending on how your server is set up, ...
    Posted to Jim 2.0 (Weblog) by James.Pipe on April 24, 2007
  • 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 likewise I have detailed below my method for returning the following basic ranges: Daily; Week ...
    Posted to Jim 2.0 (Weblog) by James.Pipe on February 10, 2007
  • 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 Whilst the entry it turned out wasn't relevant to what I was searching for, it did ...
    Posted to Jim 2.0 (Weblog) by James.Pipe on February 3, 2007
Powered by Community Server (Personal Edition), by Telligent Systems