Need inputs to use :{PARAMETER.P_TIMEZONE} in the Value set from clause.
in HCM Extract
Summary:
Need inputs to use :{PARAMETER.P_TIMEZONE} in the Value set from clause.
Content (please ensure you mask any confidential information):
In the custom HCM Extract we are getting the date and time zone in a different attributes. We need to combine both date and time zone and get the corresponding value in 'GMT' time zone. Need inputs to use :{PARAMETER.P_TIMEZONE} in the Value set from clause.
Ex: select from_tz(to_timestamp('19-03-2013 06.53.57.000000000 PM', 'DD-MM-YYYY HH:MI:SS.FF AM'),:{PARAMETER.P_TIMEZONE}) at time zone 'GMT' tz
FROM DUAL
Version (include the version you are using, if applicable):
Tagged:
0