Jasper Reports duration field view

[levent kokseven]

I work on Jasper Reports Studio. Reporting tool connected to SD object layer. I created basic report and one field is duration type. I see this duration field like 1/1/70 4:00 PM when see preview screen. I want to see as seconds. How to do that?

SD version is 17.1

[Legacy User]

Hi,

The 'pdmseconds' function can be used to convert a duration field to an integer number of seconds.

For example:

select chg.chg_ref_num
 , chg.sched_start_date
 , pdmseconds(chg.sched_duration) as dur_sec
 , chg.sched_end_date
 from chg
 where chg.sched_start_date is not null and chg.chg_ref_num not like 'U%'

Regards,

James