Does Your Database Know Which Week It Is?

Where can you find the SAP BusinessObjects BI platform maintenance schedule calendar?

SAP maintains a release calendar for the SAP BusinessObjects BI platform, indicating by week when various support packs and patches are scheduled to arrive. For example, SAP BusinessObjects BI 4.2 SP8 is supposed to arrive in week 7 of 2020.

SAP BusinessObjects Maintenance Schedule

It will be the first release of BI 4.2 that does not sport new features and will only deliver bug fixes and additional platform support (browsers, databases, operating systems, etc.). If you haven’t patched in a while, BI 4.2 SP8 should be a safe place to hang out while you wait for SAP BI 4.3 (currently in beta) to become generally available (GA).

But which week is the current week of the year? Your database has functions that can help.

For Microsoft SQL Server:

SELECT datepart(week, getdate())

For Oracle:

SELECT TO_CHAR(SYSDATE, 'IW') FROM DUAL (ISO week)

OR

SELECT TO_CHAR(SYSDATE, 'WW') FROM DUAL (starts on January 1)

According to Wikipedia, ISO Weeks ‘IW’ “start with Monday. Each week’s year is the Gregorian year in which the Thursday falls.” So for 2020, the ISO week started on Monday, December 30, 2019 while the standard week ‘WW’ started on Wednesday, January 1, 2020.

For SAP HANA:

SELECT WEEK(CURRENT_DATE) FROM dummy

According to my databases, we are in week 3 of the year, so four more weeks to go before we can download the next patch release of the SAP BI platform.

SQL in a Nutshell

SQL in a Nutshell is available in the iTunes App Store or from traditional booksellers like Amazon.com.

I have a soft spot in my heart for O’Reilly Media. I was first introduced to O’Reilly, aka “the animal books” many years ago in college. I believe my first O’Reilly book was Unix in a Nutshell. It still occupies a space on my bookshelf. Next to it is Learning the Korn Shell. Later, O’Reilly moved beyond it’s traditional Unix and C into Oracle books. I really appreciated Oracle SQL*Plus: The Definitive Guide, when using SQL*Plus as a reporting tool (way back in 1995). Recently, I grabbed a copy of SQL in a Nutshell, Third Edition for my iPhone from the iTunes App Store.

SQL In a Nutshell

Many of my technical books are reference books, meaning that you typically flip to the part you need at the moment as opposed to reading from cover to cover. O’Reilly’s SQL in a Nutshell certainly fits into this category, so I was curious to see how it would work on an iPhone.

Of course, the book is “SQL in a Nutshell”, not “mySQL in a Nutshell”, “Oracle in a Nutshell”, etc. So the book covers ANSI SQL2003 syntax (also known as SQL3), MySQL version 5.1, Oracle Database 11g, PostgreSQL version 8.2.1 and Microsoft SQL Server 2008. One of the changes since the second edition is a “reduced footprint”, which means that Sybase Adaptive Server and IBM DB2 UDB have been dumped from the discussion. I’m not surprised about Sybase (although SAP BusinessObjects Enterprise still supports it as a platform for its system and audit databases). But I was a bit puzzled why IBM DB2 was omitted, although I’m sure O’Reilly knows who their audience is.

The book is organized by topic according to the SQL3 standard as opposed to each database vendor having their own slightly redundant section. Although some might consider the first couple of chapters fluff or filler, I found them interesting, especially since my education was electrical engineering rather than computer science. Chapter one is entitled SQL History and Implementations and covers some academic database terminology, including Codd’s Twelve Principles of Relational Databases. Chapter two is entitled Foundational Concepts and reviews SQL2003 basics and sets the stage for Chapter three, which is the raison d’etre for the book: the SQL Statement Command Reference.

The book concludes with Chapter four, SQL Functions. I am frequently burned by moving amongst different database platforms. Because the book is organized by function rather than vendor, it’s a helpful presentation to understand which functions are common across platforms (although most have options and variations). Chapter four also includes, by vendor, all of the nonstandard functions. I began working with Oracle 7 in 1993 and assumed that everything I was learning was “standard SQL” – until I was on a SQL Server 6.5 project and wondered what happened to Oracle favorites like DECODE and NVL. Fortunately, most databases (including Oracle) now include a more unified CASE statement to use instead of DECODE. And COALESCE is a more flexible version of NVL, although I was surprised to see it is not part of the SQL standard, despite support from multiple vendors.

Having a handy reference on my iPhone means that there’s less stuff to carry (or miss) on traveling consulting engagements. Although SQL in a Nutshell is a book that I’d also like to have in my bookshelf, too. SQL in a Nutshell is available in the iTunes App Store or from traditional booksellers like Amazon.com.

Disclosure of Material Connection: I received this book free from the publisher. I was not required to write a positive review. The opinions I have expressed are my own. Some of the links in the post above are “affiliate links.” This means if you click on the link and purchase the item, I will receive an affiliate commission. Regardless, I only recommend products or services I use personally and believe will add value to my readers.I am disclosing this in accordance with the Federal Trade Commission’s 16 CFR, Part 255: “Guides Concerning the Use of Endorsements and Testimonials in Advertising.”