Simple date to Unix Epoch - Plateau Report Designer

[Former Member]

Hi Team,

I am using Plateau Report Designer for Custom report creation, as per the requirement i need to convert simple date format(Sep 11, 2017 11:30:10 EST) to Epoch (1572017433). Is there any Package or Procedure SF have for this conversion ?, I tried with some of the Oracle functions that is not working with PRD tool.

Thanks

Sedi

[SUMIT1]

Hi sedichelvam,

In the PRD you can use the below script to convert the timestamp to EPOCH time

SELECT SECONDS_BETWEEN(TO_TIMESTAMP('1970-01-01 00:00:00'), rev_dte) FROM PA_CPNT

Here, we are converting the revision date (rev_dte) to EPOCH time.

Regards,
Sumit Kumar