RDBPROD: How to group by week number based on DATE VMS column (Doc ID 65375.1)

Last updated on AUGUST 03, 2016

Applies to:

Oracle Rdb Server on OpenVMS - Version 6.1 and later
HP OpenVMS VAX
HP OpenVMS Itanium
HP OpenVMS Alpha

Goal

You need to have a column valued, summed, and grouped by week number based on the following definition:

A week is defined to start on Sunday. Dates falling into the last week of December are considered as part of the first week of the following year.

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms