The ARF_TIME_YEAR table stores the year part of an instant. There is one row for each year on which you want to report.

Column Name

Type

Length

Null Allowed

Description

ID

varchar

40

No

Identifier; primary key.

YEAR_OF_ERA

smallint

No

The year part of the instant. For example:

2006

YEAR_TIMESTAMP

timestamp

No

A timestamp representing the beginning of the year. By default this is midnight (Coordinated Universal Time) on 1 January.


Copyright © 1997, 2013 Oracle and/or its affiliates. All rights reserved. Legal Notices