The ARF_TIME_DAY table is used to store the day part of an instant. There is one row for each day in one year.

Column Name

Type

Length

Null Allowed

Description

ID

varchar

40

No

Identifier; primary key.

WEEK_ID

varchar

40

No

Foreign key to ARF_TIME_WEEK.ID column.

MONTH_ID

varchar

40

No

Foreign key to ARF_TIME_MONTH.ID column.

DOW_ID

varchar

40

No

Foreign key to ARF_CAL_DOW.ID column.

DAY_TIMESTAMP

timestamp

No

Timestamp representing the beginning of the day.

DAY_OF_WEEK

tinyint

No

Integer between 1 and 7, the number of the day within the week.

DAY_OF_MONTH

tinyint

No

Integer between 1 and 31, the number of the day within the month.

DAY_OF_YEAR

smallint

No

Integer between 1 and 366, the number of the day within the year.


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