Hi team.
I need to convert datetime to seconds in spel as SDM does in sql server, extract some reports and make calculations on dates using second format, every report call it calculates, so I would like to do a spel function to calculate and store the value in a field so as not to make the calculation with each report generation.
the one is: Is it possible to convert datetime to seconds in spel?
Return Example in SPEL
11/03 17:49:37.24 LLK85SH20073 spelsrvr 5904 SIGNIFICANT z_cr_calcula.spl 37 Retorno ktd:401702
11/03 17:49:37.25 LLK85SH20073 spelsrvr 5904 SIGNIFICANT z_cr_calcula.spl 37 Retorno prev_time
11/03 17:49:37.25 LLK85SH20073 spelsrvr 5904 SIGNIFICANT z_cr_calcula.spl 37 Retorno 04/18/2017 18:57:27
11/03 17:49:37.25 LLK85SH20073 spelsrvr 5904 SIGNIFICANT z_cr_calcula.spl 37 Retorno end_time
11/03 17:49:37.25 LLK85SH20073 spelsrvr 5904 SIGNIFICANT z_cr_calcula.spl 37 Retorno 04/18/2017 18:57:41
Return Example in SQL
ID prev_time end_time
401702 1492552661 1492552647