My Oracle Support Banner

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

Last updated on NOVEMBER 27, 2019

Applies to:

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


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.


To view full details, 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 a vibrant support community of peers and Oracle experts.