UDF for converting EPOCH timestamp to Date

[Former Member]

Hi Experts,

Dynamically fetching Source time stamp from SFTP sender adapter using ASMA. It's giving me EPOCH time stamp.

MTime

http://sap.com/xi/XI/System

1475028600

Please help me to write UDF for converting this timestamp to Date GMT+1:00

Many Thanks

[former_member182412 · Accepted solution]

Hi Tapasya,

Use below UDF.

Execution Type: Single Values

public String epochToDate(String epoch, Container container) throws StreamTransformationException {
  SimpleDateFormat dateFormat = new SimpleDateFormat();
  dateFormat.setTimeZone(TimeZone.getTimeZone("GMT+1"));
  return dateFormat.format(new Date(Long.parseLong(epoch)));
  }

Test:

Regards,

Praveen.

[Former Member · Accepted solution]

Thanks Praveen.

But expected output is 9/28/2016,3:10:00 AM

[former_member233209 · Accepted solution]

Hi Tapasya,

Update one line,

SimpleDateFormat dateFormat = new SimpleDateFormat("MM/dd/yyyy ',' hh:mm:ss a");

Regards,

Ajinkya

[former_member182412 · Accepted solution]

Hi Tapasya,

I think your epoch time is seconds so we need to multiply by 1000 to get the mills seconds.

Use below UDF:

public String epochToDate(String epoch, Container container) throws StreamTransformationException {
  SimpleDateFormat dateFormat = new SimpleDateFormat();
  dateFormat.setTimeZone(TimeZone.getTimeZone("GMT+1"));
  return dateFormat.format(new Date(Long.parseLong(epoch) * 1000));
  }

Test:

Regards,

Praveen.

[former_member818616]

Hi Tapasya,

My requirement is to convert Idoc date and time to EPOCH.

Do we have any UDF available for this?

Thanks in Advance.

Regards,

Imran