DARTS : Time Reformat Expressions

Class Meeting Times in CSRPT

Expression Type - Character

Length - 15

Aggregate Function? - NO

/*+Class Meeting Time Start*/
TO_CHAR(TO_DATE(SUBSTR(A.MEETING_TIME_START,1,8.),'HH24:MI:SS'),'HH:MI AM')

/*+Class Meeting Time End*/
TO_CHAR(TO_DATE(SUBSTR(A.MEETING_TIME_END,1,8.),'HH24:MI:SS'),'HH:MI AM')

/*+Class Meeting Time2 Start*/
TO_CHAR(TO_DATE(SUBSTR(A.UM_MTG_TIME_START2,1,8.),'HH24:MI:SS'),'HH:MI AM')

/*+Class Meeting Time2 End*/
TO_CHAR(TO_DATE(SUBSTR(A.UM_MTG_TIME_END2,1,8.),'HH24:MI:SS'),'HH:MI AM')