How do I extract the time part of the DateTime field?
You can extract time part of date fields using Groovy.
You can use the following
getAt():
-
ActivityStartDate.getAt(Calendar.HOUR));
-
ActivityStartDate.getAt(Calendar.MINUTE));
-
ActivityStartDate.getAt(Calendar.SECOND));
substring():
-
ActivityEndDate.format("yyyy-MM-dd HH:mm:ss").toString().substring(10,12)
For UserTimeZone value, you can use the following Groovy:
-
def value = ActivityEndDate
-
def user_time_zone = oracle.apps.fnd.applcore.common.ApplSessionUtil.getTimeZone();
-
def dateFormat = 'MM/dd/yyyy hh:mm:ss a'
-
def UTZ_ActivityEndDate = value.format(dateFormat, Time zone.getTimeZone(user_time_zone));