DBA Data[Home] [Help]

VIEW: APPS.HR_CALENDARS_V

Source

View Text - Preformatted

SELECT CALENDAR_ID , CALENDAR_NAME , PATTERN_START_POSITION ,CALENDAR_START_TIME ,PATTERN_ID ,OBJECT_VERSION_NUMBER ,CREATION_DATE ,CREATED_BY ,LAST_UPDATE_DATE ,LAST_UPDATE_LOGIN ,LAST_UPDATED_BY , TO_CHAR(CALENDAR_START_TIME,'HH24:MI') CALENDAR_TIME_START , CALENDAR_START_TIME CALENDAR_DATE_START FROM HR_CALENDARS CAL
View Text - HTML Formatted

SELECT CALENDAR_ID
, CALENDAR_NAME
, PATTERN_START_POSITION
, CALENDAR_START_TIME
, PATTERN_ID
, OBJECT_VERSION_NUMBER
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, LAST_UPDATED_BY
, TO_CHAR(CALENDAR_START_TIME
, 'HH24:MI') CALENDAR_TIME_START
, CALENDAR_START_TIME CALENDAR_DATE_START
FROM HR_CALENDARS CAL