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

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

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center