blogs.conchango.com

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, but which can be retrieved and I am looking into this when I have time. This query uses the ...

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 ...

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 ...