SQL Language (MOSC)

MOSC Banner

Oracle Calandar

edited Oct 9, 2018 5:55PM in SQL Language (MOSC) 8 commentsAnswered

Hello,

Is there Oracle calendar similar to Teradata system calendar? I'm looking for the same one that will provide data fields listed below.

CALENDAR_DATE

DAY_OF_WEEK

DAY_NAME

DAY_OF_MONTH

DAY_OF_YEAR

WEEKDAY_OF_MONTH

WEEK_OF_MONTH

WEEK_OF_QUARTER

WEEK_OF_YEAR

MONTH_OF_QUARTER

MONTH_OF_YEAR

MONTH_NAME

QUARTER_OF_YEAR

YEAR_OF_CALENDAR

WEEK_BEGIN

WEEK_END

MONTH_BEGIN

MONTH_END

QUARTER_BEGIN

QUARTER_END

YEAR_BEGIN

YEAR_END

IS_BUSINESS_DAY

BUSINESS_WEEK_BEGIN

BUSINESS_WEEK_END

BUSINESS_MONTH_BEGIN

BUSINESS_MONTH_END

BUSINESS_QUARTER_BEGIN

BUSINESS_QUARTER_END

BUSINESS_YEAR_BEGIN

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

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

Category Leaderboard

Top contributors this month

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center