AnsweredAssumed Answered

Convert datetime to seconds in spel

Question asked by ianprogrammer on Nov 6, 2017
Latest reply on Nov 6, 2017 by svetlana.kononov

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

 

 

Outcomes